2016 web app macro error (1 Viewer)

Richardr

New member
Local time
Today, 10:36
Joined
Oct 23, 2016
Messages
2
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
 

Users who are viewing this thread

Top Bottom