Unanswered: Multiple selects from a drop down field
Is it possible to do multiple selects from the data in a drop down field? I know I've worked with forms that have this functionality, but maybe they weren't coded using Access/VB. I would like to give the users a filtering form that asks them to specify the parameters of the data in which they are interested. However, I have several fields where I'd like them to be able to enter more than one item (like Class). So, if I can accept multiple selects from a single drop down, then I can use the items selected in an OR SQL statement to retrieve WHERE Field = Select1 OR Field = Select2...
You could requery the combobox after every selection to make the previous value not on the list but this could be quite messy and involve lots of code, an easier way would be to use a multi-select list box.
I can post a code example for a multi-select list box if you need it.