Query with Like Criteria not Working

[JGravesNBS]

I have a query with a Like Criteria = Like "*doz*" and the query returns records Ok

When I replace the Like Criteria with the following Like and with doz in my form filed SkillAbbrev it returns no records

Like "*[forms]![frmMember Infut_Of_Work_List]![SkillAbbrev]*"

Form Name: frmMember Infut_Of_Work_List

Unbound Field Name: SkillAbbrev

What am I missing?

 

[Minty]

Try


Like "*" & [forms]![frmMember Infut_Of_Work_List]![SkillAbbrev] &"*"

 

[spikepl]

Within quotes everything is taken literally.

"*[abc]*" looks for everything that matches the literal [ and a and b and c and ]

So by the way, the criterion was working just fine - delivering the nonsense exactly that you asked for

 

[JGravesNBS]

I see says the blind man, I should have of known that, Thank you