5 tables - 1 form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to have one form for data entry that has bound controls to 5
tables?
 
Run the form from a query, that way you can select the fields you want to show.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form Refresh 1
MS word Find and Replace using Regex - Help required 0
Lookup current record with ComboBox, any changes create new record 3
edit a bound textbox control on a form 3
Referencing Subform from Another Form 6
Populating fields via a Record Select Combo 3
Restrict entry to a text box 2
How force table update when no bound field updated? 1

Back
Top