MS Access 2007 Help! Checkbox drop-down list

m4rshmul3

m4rshmul3

m4rshmul3

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....
 
m4rshmul3 said:
Sorry I am new to Access databases, I am not sure I know what that means...
Click to expand...

With Access, you can set up code to underlie the forms and take actions based on triggers.

To ensure the list box is reset each time the record changes, you would use the oncurrent event of the form (click properties, events). The oncurrent event fires every time the record changes. You can then use this to change the selected items in the list box when the record changes, the easiest way to do this is to use the requery method on the list box.

It would look something like this

Code: 
sub form_oncurrent
list1.requery
end sub

Where list1 is the name of your list box.
 
You must log in or register to reply here.
Back
Top Bottom