How does Access save multiple select items from a List back into .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field on a form that requires multiple items to be selected from the
List Box. I changed the Properties for Multi Select to Simple and I can
select multiple items on the form. However, the items selected aren't being
saved back into the Table.
 
That is correct. The multi-select list box is not designed to save multiple
records back into one field of a table, because that is bad design. Create a
related table to hold the many records, and use a subform instead of a
listbox.
 
Back
Top