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

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