Filtering a query using a combo box 1

[adherennium]

Hi,

Does anyone know how I can set up a query to filter using a combo box, for example a list of customer names, so that if one name is selected only those records pertaining to that customer are show, BUT if no customer is selected then all customer records are shown?

I want to be able to filter on about 5 different optional criteria and writing a separate slightly different query and report for each one seems inefficient.

Thanks in advance.

Rob
(adherennium)

 

[JPMontreal]

Hi,
On the form you will use to run your query, create combo boxes for each criteria you wish to use. Populate them with appropriate Union query like this:

Select "*" from Customers UNION (SELECT DISTINCT Customers.CompanyName
FROM Customers
ORDER BY Customers.CompanyName);

This put a star at the beginning of your list. That will show, when selected, all data.
In the criteria of your query, put, all on the same line, the combo name that has the information for that field.

Forms![MyForm]![Combo45]



Jean-Paul
Montreal
jp@solutionsvba.com

 

[adherennium]

Thank you for this simple and elegant solution. Very much appreciated.