I have a query that I am trying to type this into the criteria field in design view:
Like "*" & [Forms]![Counter Partial Criteria].[txtCustomer] & "*"
The problem is that if the txtCustomer field is blank on the form that opens a split form that is hooked up to this query, it doesn't show all the records. Some of the records do not exist with this criteria filled into the query and even if I type in the criteria to search for the record that is not showing in the split form, it won't be able to find it. It's like this criteria hides certain records from existence. If I delete the criteria in the design view query, all records show but now I can't search because it's no longer looking for a value in the txtCustomer field.
Please help. Thanks.