list box

[nerd]

i have a list box that can select multiple values, but it
doesn't store any of them in the desired field in the
table. how do i solve this or get around it?

 

[Wayne Morgan]

The value of the listbox is stored in the Control Source's field. The value
of the listbox is from the Bound Column of the selected row. This is for a
single select listbox. For a multiselect listbox you have to loop through
the ItemsSelected property to get the values for each selected row, these is
no "value" for the listbox itself when using a multiselect listbox. Also,
you shouldn't store multiple values in a field. This makes the data very
difficult to sort through and retrieve later. Instead, you may need multiple
fields, perhaps several Yes/No fields, one for each possible selection.
Multiselect listboxes usually aren't used for "data entry", they are used
for "criteria selection" such as "I want to see the players on the selected
football teams."