filter problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • molen malat
    New Member
    • Oct 2006
    • 15

    filter problem

    How do I filter a Query in Access with multiple combo boxes on a Form, such that when selections are made from say four combo boxes at once, they work together like AND statements, but if they are left blank then ALL records are returned, so that the Query is filtered progressively by each combo box selection, and not filtered if no selection is made?
  • MMcCarthy
    Recognized Expert MVP
    • Aug 2006
    • 14387

    #2
    Can you post the text of the query based on all cbo values being set. It can then be adapted to allow for nulls by the experts.

    Comment

    Working...