Combobox with checkboxes

[Eddyoftheyear]

Hi All,

This may seem crazy, but I need to create a combobox with options to select more than one option. The reason is that one product may have several suppliers. I found a combobox in the northwind database in access 2007 this feature, but I don't know how they built it.

Has anyone worked on something like that?

 

[MajP]

What you are looking at in 2007 is a multivalued field. This is a single field that holds multiple values separated with a comma. There are limitations to using multi valued fields. However, contrary to most thought, these fields are normalized behind the scenes.

http://office.microsoft.com/en-us/access-help/guide-to-multivalued-fields-HA001233722.aspx

If you do not want to use a multivalued field, there is no native control to do this. You could simulate it with and expanding multiselect listbox.