Multiple combo box queries?

[HairyArse]

I can't seem to find an answer to this on the forum already, if it has been answered the please provide a link and I apologise profusely.

Anyway, I want to query a table based on various combo boxes, for example an orders table which contains details of all orders placed.

I want say for example three combo boxes, one that lists all customers, one that lists all products and one that lists all departments, so then you could choose a customer, a product and a department, then the query would filter out all records - but and here's the catch, how do I make the query so that it accepts any combination of the three combo boxes, say for example you only know the customer and the department?

Also, can a similar thing be done so that when you select the customer, the next combo lists all items relevant to that customer, I think this is called heirarchical combo boxes.

The same could apply to customers and order numbers, you select the first combo box which contains all customers, then you select the second combo box which would display all OrdersNumbers belonging to that customer.

Thanks in advance guys, this forum is a life saver.

 

[maxmangion]

I want say for example three combo boxes, one that lists all customers, one that lists all products and one that lists all departments, so then you could choose a customer, a product and a department, then the query would filter out all records - but and here's the catch, how do I make the query so that it accepts any combination of the three combo boxes, say for example you only know the customer and the department?

You can do this at form level, by using the filter by form.

Also, can a similar thing be done so that when you select the customer, the next combo lists all items relevant to that customer, I think this is called heirarchical combo boxes.

Search this forum for "Cascading Combo Boxes", there are several threads covering this topic, including one in the FAQ Section.