Link to home
Start Free TrialLog in
Avatar of pbo1
pbo1Flag for United States of America

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
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

An Option Group is mutually exclusive.  How are you selecting more than on Region?

mx
Avatar of pbo1

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..
Avatar of pbo1

ASKER

I intended to say above You can NOT select more than 1 region.
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pbo1

ASKER

Hey DB MX...

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
"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.
Avatar of pbo1

ASKER

I added 5 checkboxes