Query Criteria

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Pookaroo85
    New Member
    • Nov 2013
    • 34

    Query Criteria

    I have a form with a StartDate, EndDate and 8 combo boxes to filter a query. The user is required to enter dates but needs to be given the option to use none/some/all of the combo boxes. The date criteria works with a between statement but I cannot for the life of me get the combo boxes to filter the query without wiping EVERYTHING out. I have unbound combo boxes that reference the query for appropriate options and the query uses the combo boxes to filter the data. Is this a circular reference issue? If so, how do I get around it. The criteria for my combo boxes looks like this: [Forms]![frmDailyDispos]![cboCustomer] Or [Forms]![frmDailyDispos]![cboCustomer] Is Null

    Thanks in advance!!!
  • Pookaroo85
    New Member
    • Nov 2013
    • 34

    #2
    I figured it out. Although it is not highly looked upon, I had to use... Like "*" & [Field] & "*"

    Comment

    Working...