Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2010

    Unanswered: Query criteria based on multiple combo boxes

    I have a Form (Form1) with 3 cascading combo boxes (cboState, cboCity, cboName) that drive the criteria for a query. I need the query to select records based on all three combo boxes if all three combo boxes have values, but also based on one or two combo boxes if the other(s) are empty.


    If cboState has a value and cboCity and cboName are not selected, the query must return all records that match the selected State.
    Then if cboCity is selected, the query would filter to only show the records that match the selected State AND City.
    Then if cboName is selected, the query would filter to only show records that match all three criteria.

    The problem lies in having the query only select the appropriate records if only State or only City and State are selected. Please help!

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    please do not multi post the same question.
    if you feel the question hasn't been answered in an appropriate time then you can bump the post to the top of the list by, say, typing bump....
    in this case however I think you are being far to demanding, some 27 minutes lapsed between the original post and the SECOND post, a mere 6 minutes before the FIRST post.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Feb 2010
    Sorry internet connection froze when I clicked "Submit" and it accidentally posted my Thread twice. I don't even know how I got it posted twice in the same thread...

    I tried removing the other duplicate post but couldn't find a way to do that...

    Sorry again...

  4. #4
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    No problemo! I whipped out the handy-dandy thread tidier, and voila!

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Tags for this Thread

Posting Permissions

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