Query by Form - Select All Feature on the dropdown lst

[kcdoell]

Hello:

I have a form that I am using to help me display a query that I have built. On that form I have multiple combo boxes that I have called cobMonth, cobYear, cobWorkingRegion, etc... (basically these are certain field names in my query). I also have a command button called “Run query”. Currently, I have designed it so that if I select any of the options in my dropdown list I am able to narrow down my query result. I accomplished this by using the “criteria” row in my query and pointing the appropriate fields to my form (forms.QueryMenu.cobMonth, etc..)

Now I want to have a "Select All" option in my dropdown list. I figure out how to add the selection of "Select All" in my dropdown list but I am now clueless on how to get it to pull up all records if that is selected for any one of my parameters.

Does anybody have any idea where I can go from here? Since I am not an expert with Access, I am not even sure if there is a better way of getting all the records to populate since everything else is currently working.

Any help would be greatly appreciated.

Thanks,

Keith.