Field 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 from
the Contacts form, 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

 

[Tom van Stiphout]

You could use an expression that includes DFirst, but I would suggest
using a subform. I probably wouldn't bother with trying to only
display the first contact (first what? alphabetically?) but you could
make the subform narrow so it only displays one or a few records at a
time. When you drop the Contacts table on your form, the wizard will
step you through creating a subform.

-Tom.
Microsoft Access MVP