424,303 Members | 1,339 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,303 IT Pros & Developers. It's quick & easy.

Query Criteria

P: 34
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!!!
1 Week Ago #1
Share this Question
Share on Google+
1 Reply

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

Post your reply

Sign in to post your reply or Sign up for a free account.