Populate a Text Box on Form with Field from Another Table

[jsteff]

I have a form with a text boxes for PROJECT_CODE and START_DATE. (and 30 other fields).

The "START_DATE" is a field in the MASTER table that is the basis for the form.

However, the START_DATE should ALWAYS be retrieved from the
"SCHED" table based on the PROJECT_CODE.

Is there a simple way to do this? Should i use the expression builder?

thanks.

 

[ZmrAbdulla]

Hope your SCHED table has fields called START_DATE and PROJECT_CODE
YourTextBox= DLookup("[START_DATE]", "SCHED", "[PROJECT_CODE] =& Forms![FrmName]!PROJECT_CODE)
for more on this try Dlookuo in help file.

Zameer Abdulla
Visit Me (New Look & style)