MultiSelect

  • Thread starter Thread starter Outta Luck
  • Start date Start date
O

Outta Luck

I have a list box, in my table, with multiple values and
the goal is for the user to be able to select a
combination of those values and have those values write
back to the master table.

I have the MultiSelect Property set to Simple and in the
form, I am able to select as many values as needed.
However, those values are not saved and written back to
the master table.

So, the question is not just why aren't they writing back
to the table but how can this be corrected.

Ed
 
Outta Luck said:
I have a list box, in my table, with multiple values and
the goal is for the user to be able to select a
combination of those values and have those values write
back to the master table.

I have the MultiSelect Property set to Simple and in the
form, I am able to select as many values as needed.
However, those values are not saved and written back to
the master table.

So, the question is not just why aren't they writing back
to the table but how can this be corrected.
Click to expand...

Because it is contrary to the basic principles of relational database
design to store multiple pieces of information in one field, a
multiselect list box cannot be bound to a field. You need to create a
related table to hold the multiple items that are related to the current
master record. Once you have created such a table, the built-in, easy
way to update it is via a subform. You *can* use a multiselect list box
to present and edit the related data, loading and unloading the selected
items from the table, but it requires some VBA code to make it happen --
it's not a natural feature of the list box.
 
Back
Top