pbo1
asked on
How do you allow multiple values to be selected for a MS Access 2003 filter
I have a form with a option group called Region. The options are
East
West
Midwest
South
All
When someone clicks on West within the option group a Case statement determines the Option value selected and re queries the data to show only the records for the value selected (in my example then only West records would display. If someone selects South all the records for South appear, etc...
However, my dilemma is what if someone wants to view 2 values such as South and West...The below link shows the basic structure of my option group and form using a Case Statement. http://www.databasedev.co.uk/option_group_filtering.html
East
West
Midwest
South
All
When someone clicks on West within the option group a Case statement determines the Option value selected and re queries the data to show only the records for the value selected (in my example then only West records would display. If someone selects South all the records for South appear, etc...
However, my dilemma is what if someone wants to view 2 values such as South and West...The below link shows the basic structure of my option group and form using a Case Statement. http://www.databasedev.co.uk/option_group_filtering.html
ASKER
You can select more than 1 more region. In my example I can only slect West or South not both. You can only select one. My question is how can I allow someone to select multiple values..I realize I need to use a solution other than a option group, but what would a suggestion be..
ASKER
I intended to say above You can NOT select more than 1 region.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hey DB MX...
So you are thinking that I should remove the Option Group and create 5 check boxes ?
So you are thinking that I should remove the Option Group and create 5 check boxes ?
Well, if you need to select more than one ... yes. But you only need 4 check boxes, since any combination can be checked.
mx
mx
"and create 5 check boxes "
As DatabaseMX suggested you may have 4 checkboxes, but as you understood may be appropriate.
All can reduce the check/uncheck operations, checking All adds checks to other 4, unchecking All unchecks the other 4.
THis can be useful, if you have 3 checked and want to clear them. Check - Uncheck All clears the other 4.
As DatabaseMX suggested you may have 4 checkboxes, but as you understood may be appropriate.
All can reduce the check/uncheck operations, checking All adds checks to other 4, unchecking All unchecks the other 4.
THis can be useful, if you have 3 checked and want to clear them. Check - Uncheck All clears the other 4.
ASKER
I added 5 checkboxes
mx