Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1465
  • Last Modified:

ComboBox with checkboxes for multiple selections

I have searched EE on this topic and I have seen 'listboxes do multiple values not combo boxes". However, when I downloaded the sample 'Students' 2007 database I see that it can be done, I just don't get how.  Here are my examples:

 Has checks This is the value Shows that its a ComboBox
I just don't see anything anywhere that says how to do this. Thanks for any help you can give me.
0
G Scott
Asked:
G Scott
3 Solutions
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Your not quite looking at the same thing.

Access 2007 introduced a feature called Multi-value fields, which allow you to define a field at table level to accept multiple values.  It really doesn't (accept multiple values in a single field), but creates associated tables to make it appear that way.

 The thing you refered to in your question on a list box is called multi-select and it's a property of the control.  And yes, it's true that combo's still don't have that feature.  you can only pick one value at a time from a combo.

JimD.
0
 
Jeffrey CoachmanMIS LiasonCommented:
So, yes you can use Muti-valued fields to do this in an Access 2007 formatted Database.

However you really need to understand how they work and what is really happening behind the scenes.

Many Experts here tend to shy away from them, and they do have some "issues"

A lot of people wrongly use them as a One to many, when really they are Many to many constructs.

Many members here have twisted themselves in knots because of the potential complexities.

So perhaps you should take a step back and explain your table design and relationships, and then explain exactly what it is you are looking to achieve.

JeffCoachman
0
 
Jeffrey CoachmanMIS LiasonCommented:
See this link and the samples contained therein for one technique for setting up a multiselect Listbox:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23695043.html
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Helen FeddemaCommented:
Also see my Access Archon article on multi-select fields (though I agree that they have issues, and I generally avoid using them myself).  Here is a link for downloading it:

http://www.helenfeddema.com/Files/accarch159.zip

0
 
Helen FeddemaCommented:
For a multi-select listbox used for filtering data, see Access Archon #197

http://www.helenfeddema.com/Files/accarch197.zip

Here is a screen shot of the form in the sample database:
Filtering-by-Listbox-Selections.jpg
0
 
G ScottAuthor Commented:
Thanks for the input everyone. I got it figured out.

Helen - AWESOME sample DB. Thanks!
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.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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