BASIC QUESTION

[Guest]

Is it possible to create a form that draws data from more than one table? Is
so does it have to use a query?

 

[John W. Vinson]

Is it possible to create a form that draws data from more than one table?
Yes.

Is so does it have to use a query?

Yes; either a query or (more commonly) a main form for one table and a subform
for the other.

For a more detailed answer please post a more detailed question!

John W. Vinson [MVP]

 

[fredg]

Is it possible to create a form that draws data from more than one table? Is
so does it have to use a query?

Yes you must use a query.
Note: Some queries are not updateable.
See Access help:
Query + Troubleshoot queries + Select Query + I can't update data
from a query + Data can't be updated

However, if you just need to DISPLAY (or use in a calculation) the
data stored in a different table field, you can use DLookUp(), i.e.
=DLookUp("[FieldName]","OtherTableName","Where Clause arguments")
Look up DLookUp as well as
"Restrict data to a subset of records" for help with the arguments
needed" in VBA help