• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

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
0
pbo1
Asked:
pbo1
  • 4
  • 3
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
 
pbo1Author Commented:
I intended to say above You can NOT select more than 1 region.
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
 
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 MVP, Access and Data Platform)Commented:
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

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now