Get query data from form for multiple fields not working......

[shelnrik]

Help I am working on a database for a client I have a query that is getting the criteria from a form. For example they can query the Gender, VP, VPO, Store, HireCode, Date
When we get to the 5th criteria the query does not update anymore ...for instance I was running it using dates, store, VP and Hirecode and when I added the criteria of F for female the query did not update.

What am I doing wrong.
My Criteria is using the Like "*"& [forms]![OPENjobQryForm]![Gender]&"*"
I also have a requery button and that did not seem to update the data.....

 

[xenou]

Would need to see the whole query but probably you need single quotes around your text criterion:

Like "'*" & [forms]![OPENjobQryForm]![Gender]&"*'"

Hard to see but if you look you see single quotes are added in the above.