Query based on cascading combo boxes

[Vaporhead]

Hello!



I've been out of the Access world for many years, but I find myself back in again.

I have a form [frmZoneData] that have three unbound combo boxes: cboArea > cboZone > cboStore which filters my results in a query [qryZoneFindingsData].

I can get the results I need IF I fill in all the combo boxes, but there are times where I need to run the query based just on either the cboArea or cboZone drop downs, leaving the other(s) blank. If I leave any of the drop downs blank currently, I get no results.

Any assistance would be great!\


~Mark

[pbaldy]

See if this works for you.

http://www.theaccessweb.com/queries/qry0001.htm

Note it will likely jack up design view, but it still works.

[Vaporhead]

Woah, that worked! Thanks!

[pbaldy]

Happy to help and welcome to the site by the way!