Help with Multiple Select List boxes (1 Viewer)

[ds0203]

I have a list box in a form that I have set to allow multiple selections but I can't get the code right to save the selections that are made, not quite sure what I need to do here. Every time I close the form and reopen it or open up the table housing the data for the form the selections are gone. Any help would be greatly appreciated. Thanks!

 

[Bat17]

A multiselect listbox will not save records directly, you need to use code to do something with the values selected.

Peter

 

[ds0203]

I realize that, and since I didn't initially set up this database it's not how I would have done it, but it is what I have to work with. How do I set the code (I'm semi-familiar with VB) to save the values selected into that field? Or do I need to have a different field to save the values to?

 

[pbaldy]

Code here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;210203

though even here it includes the caution:

Although this article demonstrates how to store multiple selections from a multiple-selection list box into a single field, you should realize that it is not good database design, and you should explore alternatives. Storing a list of values in a single field violates basic rules of database normalization theory.