Multiselect list box into one column

[Ammarhm]

Hi Guys
I have created a database in which the user has an input form, one of the controles used in the form is a list box allowing multiple selection (Multiselect propery = simple) I have 3 items in the box and the form is linked to a table
My question is the following:
Is there a way to store what the user chose (single or multiple items) into one column??
I would really appreciate your answer as i am very stuck on this

 

[pbaldy]

It is generally not a good idea to store multiple values in one field, though it can be done. Here's a method, though note even this KB recommends against storing data that way:

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

 

[Ammarhm]

Thank you so much for the quick respons
Let us say that i instead use three columns in my database to store the selected items (three items in the list box, three columns in DB, one for each item setting a value or check box if item selected in list box) what would the appropriate aproach be??
Thanks again

 

[pbaldy]

The "normalized" solution would be 3 records (rows) in a related table rather than 3 fields (columns). You would use the standard code to loop through the selected items, and inside that loop append a record to that table for each selected item.

 

[Ammarhm]

Really appreciate your help7
Could you please help me with the VBA code??
I attached a similar design form to my problem
I would really appreciate if you could take the time to help wth the code
Thanks again

 

[pbaldy]

This prompted me to add a little demo to my website, so see if this helps:

http://www.baldyweb.com/MultiselectAppend.htm