View Single Post
  #3  
Old May 2nd, 2008, 09:48 PM posted to microsoft.public.access.forms
David W. Fenton
external usenet poster
 
Posts: 3,373
Default Can I allow two or more selections in a drop down list ?

"Douglas J. Steele" wrote in
:

Combo boxes (the Access name for drop down lists) are limited to
only selecting one value. If you need multiselect, consider using
a list box.


If it's being used to select WHERE criteria, you could combine the
combo box with a text box, and add values to it separated by OR, and
then pass the contents of the OR clause through
Application.BuildCriteria() and end up with a proper WHERE clause
from it. I do this all the time on my query-by-form interfaces.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/