Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Posts
    36

    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...

  2. #2
    Join Date
    Dec 2002
    Location
    Glasgow, UK
    Posts
    100
    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.

  3. #3
    Join Date
    Apr 2003
    Posts
    36
    Yes please. I don't know anything about these, but they sound right.

    Thanks

  4. #4
    Join Date
    Apr 2003
    Posts
    36
    Let me know if you can help me with setting up one of these.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •