By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,435 Members | 2,939 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,435 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!!!
Feb 11 '19 #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] & "*"
Feb 11 '19 #2

Post your reply

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