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
pbo1Asked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
Well, ideally you would use a List Box set to Multi Select mode.  But that's a be more complicated.   For your case, since there are a max of 5 choices, I'm thinking 5 check boxes, actually 4 ... because the 'All' case would be all 4 boxes checked.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
An Option Group is mutually exclusive.  How are you selecting more than on Region?

mx
0
 
pbo1Author Commented:
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..
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
pbo1Author Commented:
I intended to say above You can NOT select more than 1 region.
0
 
pbo1Author Commented:
Hey DB MX...

So you are thinking that I should remove the Option Group and create 5 check boxes ?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Well, if you need to select more than one ... yes.  But you only need 4 check boxes, since any combination can be checked.

mx
0
 
hnasrCommented:
"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.
0
 
pbo1Author Commented:
I added 5 checkboxes
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.