BASIC QUESTION

N

Novice2000

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

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?
Click to expand...

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]
 
F

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?
Click to expand...

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
 
Top