MS Access 2007 Help! Checkbox drop-down list

Associate
Joined
4 Mar 2009
Posts
36
Hi,

I have a table that contains a multi valued lookup field, I now need to display this data on my form by way of a Checkbox drop down list, which is essentially a combo box set to support multiple values. I have been searching the web for ages and cant find the answer to the question -

Where is the option for allowing multiple values on a combo box?

Once selected I should have my list of countries with checkboxes next to them.

Any help greatly appreciated as this is driving me nuts!
 
Thats what I resorted to doing, however I now have a problem in that I want the selected values to be referenced on each record. As it stands If record 001 has France selected, I then go to new record Paris is still selected. Although my table updates fine....
 
Back
Top Bottom