Query with dropdown box

[Alsail77]

I have a query which pulls its parameters from a Form [Main] to preform a search. One of the fields the query searches by is a Combo Box/Dropdown list [Combo94]. All Records have five possible results for this field (call them "A"-"E" to make it easy).


I want to make it so that when performing the search the user can either, select one of the five options (A-E), or they can select a sixth option "All", which will select all records (effectivly ignore this criteria). Currently I have the criteria set to [Forms]![Main]![Combo94] which obviously works when options A-E are used.

If it makes a difference, this query runs a search on five other fields at the same time.

Thanks,
Alex

[June7]

If you want to accomplish with only the simplest VBA code, review this method http://datapigtechnologies.com/flash...tomfilter.html

With this technique, the sixth option would be an empty string from the list or just leave the box blank, not the word 'All'.

[Alsail77]

Thanks, June7. I managed to implement that with ease. I was stuck on thinking "All" was an important option for the user to see and failed to think of leaving it blank as an option.