Changing criteria in queries

[pompeyjim]

I want to search a database (using queries) for Orders using [Enter Order No]
as the criteria and I also want to search for Orders using [Enter Company
Name]. Is there any way of changing the criteria using VBA (or any other
method for that matter) so that I need only one query? I am currently using
two queries, qrySearchOrderNo & qrySearchCompName. The fields in both are
exactly the same.

 

[Duane Hookom]

I would create an unbound form that allows the user to select from multiple
different criteria against different columns/fields. Martin Green has lots
of tips on how to do this at http://www.fontstuff.com/access/index.htm.