help with Expression Builder

M

meilani

What is the syntax (for a text box) for the Expression Builder for accessing
column A in table 1 on a form whose Record Source is coming from table B?
 
J

John Vinson

What is the syntax (for a text box) for the Expression Builder for accessing
column A in table 1 on a form whose Record Source is coming from table B?
Click to expand...

Probably a call to the DLookup function:

=DLookUp("[A]", "[Table 1]", "<optional criteria>")

but it would help a lot to know what you're trying to accomplish!

John W. Vinson[MVP]
 
Top