Add field to existing form

  • Thread starter Thread starter Colleen
  • Start date Start date
C

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