Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    multiple choices from a list box to use in a query (Access 2000)

    I can get a query to pick up a single selection from a list box - but how do I get it to pick up multiple selections?

    Thanks

    Roberta

  2. #2
    2 Star Lounger
    Join Date
    Apr 2003
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: multiple choices from a list box to use in a query (Access 2000)

    You have to enable "Multi Select" option in the list box properties.

  3. #3
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: multiple choices from a list box to use in a query (Access 2000)

    thanks I have now done this - but how then do I get my query to pic up all these selections?

    Cheers

    Roberta

  4. #4
    2 Star Lounger
    Join Date
    Apr 2003
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: multiple choices from a list box to use in a query (Access 2000)

    That's a great question and I wouldn't mind hearing the answer myself!

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: multiple choices from a list box to use in a query (Access 2000)

    The only way to get at the selected items in a multi-select list box is through Visual Basic code. Using the selected items in a query is not easy (I think) unless you re-create the SQL for the query in code (and that is not trivial either). MSKB article How to Use a Multi-Select List Box to Filter a Form gives some examples of using a multi-select list box.

    If you explain what you want to accomplish, we may be able to help you find a way to do it.

Posting Permissions

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