Multiple Combo Box query

[mssbass]

I have a form with 2 combo boxes. The query that I run off this form will run fine when I select a value in both boxes but when I leave the 2nd combo box "blank" or "null", the query will not run.

For example:

I select "ABC Company" in my first combo box and for the 2nd combo box I want to see "all the products they ordered" not just a specific product in my value list (Paper, stamps, pens). How do I see ALL PRODUCTS???

 

[thornmastr]

Make “ALL PRODUCTS” a viable choice for the 2nd combo box. Check the value of the 2nd combo box for “ALL PRODUCTS”. Obviously, if true, you want your select to start with SELECT * FROM TABLENAME rather than SELECT * from tablename where product type = “ribbons”, etc.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[motoguy]

Forgive my ignorrance. How do I make "All Products" = to * in the query?
Thanks for your help,