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!
Help with Multiple Select List boxes
- Thread starter ds0203
- Start date
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?
- Local time
- Yesterday, 23:13
- Joined
- Aug 30, 2003
- Messages
- 36,275
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.
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.
Similar threads
