Hi,
I'm trying to compose a macro in a web app, which is failing at the first step. What I eventually aim to do is to send the key info entered in a form, by e-mail, to a consultant who is nominated in that form.
The form populates the table "Papers" and there's a separate table "Consultants" containing the consultant's contact details.
In Papers, there is a lookup of the consultant's surname for the user to select. This field is bound to Consultants by the primary field "Consultant_ID".
My data macro reads:
Look Up A Record In Consultants
Where Condition = [Consultants].[Consultant_ID]=[Papers].[Consultant]
SetLocalVar
Name mailaddress
Expression=[Consultants].[mail_address]
However, stepping through or trying to save this, the first expression pops up an error saying "Unable to resolve reference to 'Papers'. Common causes to check: (1).............
Well, I've checked the "common causes" but I can't seem to spot the problem. Does anything immediately stand out to the experts here?
Many thanks,
Richard
I'm trying to compose a macro in a web app, which is failing at the first step. What I eventually aim to do is to send the key info entered in a form, by e-mail, to a consultant who is nominated in that form.
The form populates the table "Papers" and there's a separate table "Consultants" containing the consultant's contact details.
In Papers, there is a lookup of the consultant's surname for the user to select. This field is bound to Consultants by the primary field "Consultant_ID".
My data macro reads:
Look Up A Record In Consultants
Where Condition = [Consultants].[Consultant_ID]=[Papers].[Consultant]
SetLocalVar
Name mailaddress
Expression=[Consultants].[mail_address]
However, stepping through or trying to save this, the first expression pops up an error saying "Unable to resolve reference to 'Papers'. Common causes to check: (1).............
Well, I've checked the "common causes" but I can't seem to spot the problem. Does anything immediately stand out to the experts here?
Many thanks,
Richard