Solved

How do you allow multiple values to be selected for a MS Access 2003 filter

Posted on 2010-08-29
8
266 Views
Last Modified: 2012-05-10
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
Comment
Question by:pbo1
  • 4
  • 3
8 Comments
 
LVL 75
ID: 33555644
An Option Group is mutually exclusive.  How are you selecting more than on Region?

mx
0
 

Author Comment

by:pbo1
ID: 33555738
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
 

Author Comment

by:pbo1
ID: 33555740
I intended to say above You can NOT select more than 1 region.
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 33555749
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
 

Author Comment

by:pbo1
ID: 33555759
Hey DB MX...

So you are thinking that I should remove the Option Group and create 5 check boxes ?
0
 
LVL 75
ID: 33555784
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
 
LVL 30

Expert Comment

by:hnasr
ID: 33557534
"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
 

Author Closing Comment

by:pbo1
ID: 33605267
I added 5 checkboxes
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question