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
|
|||
|
|||
Saving data selected from a list box to a table
I have 2 multi-select list boxes on a form but none of the data selected is
saved to the table with other data selected via combo boxes, or entered as frree text or dates. How do I get the data to save (I am not trying to save back to the table referenced by the list boxes). -- Erika |
#2
|
|||
|
|||
Saving data selected from a list box to a table
Erika
If you are using "multi-select list boxes" the implication is that there is a one-to-many relationship between the data/record represented by the rest of your form and the selections in (each of) the list boxes. To get the best out of Access' relationally-oriented features/functions, you'll need to store your data relationally. If you really do have a couple one-to-many relationships, you'll need at least one additional table per list box. The additional table(s) will hold the recordID of the form's record and the recordID of (each) selection on the list box. ?4 items selected? ... 4 records in the new table. -- Regards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ "Erika" wrote in message ... I have 2 multi-select list boxes on a form but none of the data selected is saved to the table with other data selected via combo boxes, or entered as frree text or dates. How do I get the data to save (I am not trying to save back to the table referenced by the list boxes). -- Erika |
Thread Tools | |
Display Modes | |
|
|