We help IT Professionals succeed at work.

Access using query as the data source ofa  form

Murray Brown
Murray Brown asked
on
Hi
In Access I have two tables that are related as shown in the following query.
I want to use both tables as the data source of a form. Should I created a joined query and use this as the data source of the form?
Thanks

1
Comment
Watch Question

Consulting
BRONZE EXPERT
Distinguished Expert 2017
Commented:
To my knoweldge, a form can only have one data source:
Either one table, or one query.

So if you want to gather data from several tables, then yes, you will need a query.
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Great. Thanks