Combo Box Select All Help

[dungeon]

Hi,

I have a query that runs from a couple of cbos and I was wondering how I can 'select all' from these. The cbos are populated using values from different tables.

At the moment all I can do is select one of the options specifically for every cbo and all cbos must have a selection for the query to run. If possible I would like the option of leaving one/many cbos blank and the query returning all values for that field (or basically ignoring that criteria).

Is this possible or is there another way around this?

Cheers

 

[pbaldy]

Several ways; here's one:

http://www.mvps.org/access/queries/qry0001.htm

 

[dungeon]

Great. I had found another way but it was fairly complicated (for me) but this is much easier.

Thank you