how to store the data from a multiple selction list box?

  • Thread starter Thread starter hastit
  • Start date Start date
H

hastit

I have looked through some of the other questions similiar, but the
answers aren't making sense to me.
I have a form with list boxes- set to accept multiple selections.
How do I get it to put the data into the table?

any help would be greatly apreciated. Thanks,
T Hastings
 
A multi-select list box is not intended for storing the multiple selections
into a table. Use a related table and subform instead.

If you know how to write VBA code, it is possible to write code in several
different events to achieve this. As well as the events of the list box, you
would need to write code for the Current, BeforeUpdate, Delete,
AfterDelConfirm and Undo events of the form. This code would involve opening
recordsets, and executing Append, Delete, and Update queries. If you
understand VBA and these events well, you probably understand why this is
not a great way to go.

Instead, create the related table to hold a record for each choice. (You
would need anyway, even if you did use the list box.) Then add a subform
where the user can select the choices one per row in the subform, for the
record in the main form.
 
Back
Top