up vote 0 down vote favorite
share [g+] share [fb]

When using a list box with multi select set to simple, how can I store the multi values that are choosen. Or is there another way to store multi results from a dropdown. I have to allow my user to pick more than one item from a list. Suggestions?

link|improve this question
0% accept rate
Maybe you should design the data storage before choosing the control for editing the data. That is, figure out how to store the data, and THEN choose whether you'll use a multiselect listbox or something else to edit. Free clue: you won't use one if you model the data correctly. – David W. Fenton Jun 28 '11 at 21:05
I hear you. If my data storage has one field for ie:names, I cannot just create a drop down or combo back and have it store 2 or 3 names in that one field. So, when using a list box with multi select=simple, how can two choices be saved. The Control Source can only be to one field.. – LtDan Jun 28 '11 at 21:23
This is usually done with a separate JOIN table and modelled in the user interface with a subform based on the JOIN table, with a dropdown list with the values for the lookup table. This is pretty bog-standard Access UI design. – David W. Fenton Jul 1 '11 at 0:34
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.