Saving multi selected list box answers to a table?

[sten28]

I’m basically trying to create a form that displays a list box that displays information from a separate lookup table that will be saved into my main table of records. I want to be able to select more than one answer in this lookup table and have the form save it into the main table.

To give an example, the question is: How did you find out about us?

The following answers in the list box - School, TV, Newspaper, Email

I’ve implemented the list box and set Multi Select to Simple, so I can select more than one answer - however, if I try to save a record with more than one answer selected, the information is not saved to the table. However, selecting just one record will save the information to the table.

I’m under the impression that I should be able to save multiple answers to this table! I would expect that the information would be saved in the table as “School; TV; Email” - the field I’m trying to save to is just plan text.

Any help would be greatly appreciated!

 

[PHV]

I would expect that the information would be saved in the table as “School; TV; Email”
Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dhookom]

I agree with PH (as usual). However Access 2007 has multi-value fields that provide the functionality you are looking for.

Duane MS Access MVP
Now help me support United Cerebral Palsy