Saving Lists

[MikeEller]

Hello,

I have a main form where the user can click on a button that opens another form. In this form, the user can make selections from one listbox and they are copied to another listbox.
How can I save the contents of the listbox into a field that is part of the record on the main form? Can this be done?
I have a listbox on the main form where the selected items will be displayed and each record of the main form will have different values for the listbox.

Any ideas?

Thanks,
Mike

 

[ted.martin]

Basically if you create an additional field in the table called (say) ListBox Contents, all you will need to then is update it.

The simplest way would be to make the Control Source of this new field = the name of the original List Box field,

Another way would be to run an Update Query to write the ListBox contents to this field. With this method, depending upon your design, you may have to hold this value in a Public Variable and run the Update query after the from has closed.