Command button on form to draw from parametized query/5 queries??

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

Guest

Good Morning

I hope someone can help me. I want to add a command button on my form which
will draw data from a table or 5 different queries (as there are 5 different
criteria and I want to be able to look at 1 of my choice.) So, I have created
5 queries, specifying a different criteria in each. I then wondered if it
would be easier making a parametized query and getting the command button on
the form to point to that, or to add a combo box to the form pointing to the
5 different queries.

Any help would be much appreciated.
Thank you in advance.
 
Both will work fine, and the outcome will be just the same. The only
difference is the parametrized query approach results in a tidier
database (fewer objects) and increased ease of maintenance - if a change
is needed, it is done in one query rather than five.

From your wording I understand the criteria for the five queries are
fixed, so personally I would use an option group on the form to select
each set of criteria, and a single query.

HTH,
Nikos
 
I managed to try both out and you were correct, they both work fine. The
option group suggestion is an interesting one never thought of that, will try
it out!

Thanks for your help and have a great day!
 
Back
Top