One form accessing two tables

[dgmorr]

Hello,

I have a form that has two fields that pull data from two tables, however, in the data source control, I can only see the fields from one of the tables. Is there a way to link the text box to a field from another table?

 

[Ron_dK]

Make a query including the two fields from the two tables and bound the form to the query, rather than the table(s).

 

[ColinEssex]

You should be using a query as the forms recordsource - not a table. You can then draw fields from various different tables

Col