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!!!
Thanks in advance!!!
Comment