5 tables - 1 form

[Guest]

Is it possible to have one form for data entry that has bound controls to 5
tables?

 

[Guest]

Run the form from a query, that way you can select the fields you want to show.

 

[Graham Mandeno]

Hi Paul

A control can only be bound to a field in the form's RecordSource. So you
need to create a query which incorporates all five tables and use that
query, not the tables, as your RecordSource.

Of course, you can also have five subforms on a form, with each bound to a
different table or query.