Can I use one form to display the results for several queries?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 4 different but simple select queries querying the same table. This is
to allow an engineer enter whatever information he/she may have about an
inventory item.

This is the first time I've designed a database at all so of course I made 4
forms to output the results. Is it possible to use just the one form?

Thanks in advance
 
You could use subforms as long as there is a relationship
between the parent form and the child form. cool things to
play with are sub forms of subforms.
 
I have 4 different but simple select queries querying the same table. This is
to allow an engineer enter whatever information he/she may have about an
inventory item.

This is the first time I've designed a database at all so of course I made 4
forms to output the results. Is it possible to use just the one form?

Thanks in advance
Click to expand...

You can and should use a single form... and you can probably get by
just fine with only one query, rather than four! If the queries differ
only by the criterion selecting which records to see, you can use a
Parameter query; if there are four choices, for instance, you could
have a Listbox or a Combo Box on your form - *UNBOUND* - displaying
the choices. The search criteria would then be

=[Forms]![formname]![controlname]


John W. Vinson[MVP]
(no longer chatting for now)
 
Back
Top