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, cobWorkingRegio n, 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.QueryMen u.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.
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, cobWorkingRegio n, 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.QueryMen u.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.