Solved

ComboBox with checkboxes for multiple selections

Posted on 2011-02-18
6
1,215 Views
Last Modified: 2013-11-28
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
Comment
Question by:G Scott
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 167 total points
ID: 34925667
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34927148
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
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 166 total points
ID: 34927204
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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 34944303
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
 
LVL 31

Assisted Solution

by:Helen_Feddema
Helen_Feddema earned 167 total points
ID: 34944322
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
 
LVL 1

Author Closing Comment

by:G Scott
ID: 34955928
Thanks for the input everyone. I got it figured out.

Helen - AWESOME sample DB. Thanks!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

730 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