showing fields from another table

  • Thread starter Thread starter JB
  • Start date Start date
J

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
 
JB said:
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
Click to expand...

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).
 
Back
Top