help with Expression Builder

G

Guest

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

expression builder sum total not entering into table but showing o 1
Hello happy new year to all, Text box input for year of purchase 0
Enable or Disable Checkbox with expression builder 3
tryin to get a form text field to update a diff field as well? 1
#Name? error with unbound text box 1
why in god's name won't calculated controls work? 6
Referencing columns from a combo box adds extra brackets 2
2nd list box not writing to text box 1

Top