If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
MultiSelect
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 |
#2
|
|||
|
|||
MultiSelect
"Outta Luck" wrote in message
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. 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. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
Thread Tools | |
Display Modes | |
|
|