Storing MultiSelect values in a table

  • Thread starter Thread starter TWoolfolk
  • Start date Start date
T

TWoolfolk

I am very new to access and need some help. I have set
up a form that allows the selection of values from a list
box. These values are being selected from one table and
stored in a separate table. The customer has now asked
for this to be a multiselect list box. I have allowed
Simple multiselect and it now allows me to select
multiple items in the list box on the form; however,
these items are not being stored in the table. Any
suggestions would be helpful.
 
The multiselect list box cannot store its value into a table.
While it is possible to write code to loop through the ItemsSelected
collection of the listbox, it's simpler and more effective to do the job
correctly.

The correct approach is to create another table to hold the various values.
It will have a many-to-one relationship with the first table, so you can
have multiple related records.

For an interface, use a form with a subform instead of the list box. The
user can select as many records as required in the subform - one per row.
Typically you provide a combo box for selecting the values, and the box is
repeated on each row for as many rows as required.
 
Back
Top