suze,
When is it best to use a subform along with a form?
Typically, subforms are used to represent data in a one-to-many
relationship. For example, Customers (one) and Orders (many); take a look
at the sample database that ships with Access, Northwind.MDB, and you'll see
how this is implemented.
Can a single form be linked to multiple tables?
Yes, it is possible to display data from more than one table in a single
form by making the record source of the form a query. However, as pointed
out by John Vinson in a recent post in another thread, the likelihood of
the data in that form being updateable is decreased with the number of
tables in the query.
How many subforms can a form have?
A subform on a form is counted as a Control on that form; the maximum number
for controls and sections on a form (in Access 2002) is 754. Use Access
Help and type the word "specifications" in the Answer Wizard to find the
limit for your version of Access; it may or may not be different from 2002.
One can maximize the use of subforms on a main form by creating a single
subform control and, when needed, changing the Control Source property of
the subform control to display a different subform.
hth,
