Saving data selected from a list box to a table

[Erika]

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).

 

[Jeff Boyce]

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


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/