Add field to existing form

[Colleen]

I have a completed form based on one table, but I need to
add a field from another table to it. If I add an unbound
control, the control source only lists the available
fields from the first table. How can I get it to
recognize the field from the second table without getting
that darn #NAME? error? Thanks.

 

[Dan Artuso]

Hi,
The only way is to add the second table to the form's recordsource.
Usually there is some relationship between the two tables and you can
build a query (using both tables) and then make that the form's record source.