Check Box

[Trojnfn]

I have a form with a box containing a pullodown list of values. However, that will only allow me to select one value. For example, my form tracks meeting notes and who attended the meeting. I want a pulldown list of all the names and a checkbox next to each. If I check the name, I want it to display on my form and then eventually get inserted into the table. How do I set that up ?

[jzwp11]

If a meeting has many attendees then that describes a one-to-many relationship, so you should have a table related to your meeting table that holds the attendees. Typically, you would use a subform bound to that table to capture the attendees. If you do not want to use a subform, then the next best approach is to use a multi-select list box. You would not need the check boxes; the multiselect list box allows you to select via ctrl+Click. You will need code to loop through the items selected in the list box in order to append those attendees to the appropriate table.

[John_G]

To allow multiple item selection in a listbox, you need to set its Multi Select property to simple or extended. For your purposes, Simple should suffice. However, you cannot use a checkbox to indicate the selected lines; just click an entry in the listbox to select it - it will become highlighted. Click the entry again to de-select it.

You will need VBA to process the checkbox entry list, something like this:

Dim lineitem As Variant
MsgBox Me!mylistbox.ItemsSelected.COUNT & " items selected" ' Just to verify the count - not required
For Each lineitem In List10.ItemsSelected
Debug.Print mylistbox.Column(1, lineitem) ' just to verify - remembering the column 1 is the second column in the listbox
'
' process each selected line in the litbox as needed
'
Next