Record Source as Multiple Tables

J

John Lundrigan

Does Access allow the record source for a form to be more than one
table explicitly? In other words, if my form's controls are to be
bound to fields from multiple tables do I have to define the record
source as a query?

Thanks

John L
 
B

Brendan Reynolds \(MVP\)

No, a record source can not consist of more than one table or query. Yes,
you will need to use a query to join the tables.
 

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

DLookup in Continuous form 0
Copy previous record into form field 0
Weekly Report 2
Access 2003: populate combobox with CSV values from table column 1
Embed the same Excel multiple times 0
Form question: Simplest way to bring in a query result that is notthe record source into a form? 3
QBF & Query Malfunction 0
How do I find the record source of a graph ??? 1

Top