Results 1 to 2 of 2
  1. #1
    Nosaj08 is offline Advanced Beginner
    Windows XP Access 2002
    Join Date
    Apr 2009
    Posts
    40

    Question Pulling a Query from a List Box

    Hey Everyone,
    I was working on my database today and ran into a slight wall. Right now I have a query pulling from a single selection in a combo box in order to create a report. However, I now need the report to be created from a list box that can have multiple selections. Once I set up a list box with a simple selection option, how would I create a query that would return values based on any of the multiple options the user selects in the list box? I will need it to be any of the options selected and not all of them. Any help on this would be much appreciated. Thanks in advance!

    Jason

  2. #2
    Nosaj08 is offline Advanced Beginner
    Windows XP Access 2002
    Join Date
    Apr 2009
    Posts
    40
    Hey All,
    Just as a follow up to my previous question, I wasn't able to figure out how to use a list box to assign multiple variables with an "Or" statement to a query. So instead, I used 5 combo boxes to create up to 5 different variable options and referred to each CB with the "Or" statement in the query. This method is more of a work around but it seems to work for now. If anyone knows another way to do this that can be more flexible with the amount of variables and without having to create a bunch of combo boxes, please let me know. Thanks!

    Jason

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Pulling value
    By Overdive in forum Forms
    Replies: 3
    Last Post: 11-08-2009, 03:07 PM
  2. Does it Matter? Pulling fields in a query
    By Canadiangal in forum Access
    Replies: 1
    Last Post: 10-01-2009, 01:53 AM
  3. Pulling out duplicates
    By FREEEEEEDOM in forum Access
    Replies: 1
    Last Post: 04-21-2009, 10:37 PM
  4. Problems with a query in a list box
    By admaldo in forum Forms
    Replies: 1
    Last Post: 04-05-2006, 05:28 PM
  5. Query List
    By sanjshah in forum Queries
    Replies: 3
    Last Post: 03-25-2006, 08:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums