showing fields from another table

[JB]

Hello
In a form I'd like to have a field from another table than the source of the
form.
Example:
The Main form has all the client data for inputting and there is a control
to open the Contacts form for up to 4 contacts and phone numbers.
In the Main form however I'd like the first contact's name to appear, but
not for editing, just for info.
Can anyone tell me how to do that.
I tried to do the build thing to add the expression but it didn't work.
Thank you
J

 

[Rick Brandt]

Hello
In a form I'd like to have a field from another table than the source
of the form.
Example:
The Main form has all the client data for inputting and there is a
control to open the Contacts form for up to 4 contacts and phone
numbers. In the Main form however I'd like the first contact's name to
appear,
but not for editing, just for info.
Can anyone tell me how to do that.
I tried to do the build thing to add the expression but it didn't
work. Thank you
J

The Dlookup() function should work for that. You coudl also use an unbound
ListBox or ComboBox (those would let you list all the contacts if desired as
well as just the first).