Filter a query three different ways depending on what the user wants

[SteelFire via AccessMonster.com]

I have a form that has three tabs (boxes that when clicked change what is
shown on the form), relating to three different ways to search and order a
query. Clicking on a tab will make the corresponding combo boxes visible and
the others not visible. I have the code for that working just fine. The next
step, and the one in which I need help, is to set the query to filter out the
records based on what the combo boxes values are as well as working if the
combo box is left blank or null. Each tab will have its own WHERE and ORDER
BY, but the same SELECT and FROM to run the query.
If you get the drift and have any other ideas, shoot them over. I am open to
any way of writing this as long as it works.
To see my database, it is here.
http://www.accessmonster.com/Uwe/Fo...72/Cascading-Lists-Need-Help#9469e77315e64uwe

It has changed a bit, but for the most part is the same.

 

[Jeanette Cunningham]

Hi SteelFire,
there is a working sample that filters just this sort of form.

http://allenbrowne.com/ser-62.html

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia