asked on

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:

I just don't see anything anywhere that says how to do this. Thanks for any help you can give me.

ASKER CERTIFIED SOLUTION

Jim Dettman (EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jeffrey Coachman

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

SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Helen Feddema

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

SOLUTION

Helen Feddema

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

G Scott

ASKER

Thanks for the input everyone. I got it figured out.

Helen - AWESOME sample DB. Thanks!