Generate Records for a form based partial field / contains

[cpinney1120]

Can anyone help me? I cant figure out how to get a form to run off a query that searchs by partial field (like anything with "gum" in it). I am using this in my query criteria but after the prompt, no records come up.
Please help:
"*"&[Enter Key Word]&"*"

 

[MSAccessRookie]

Can anyone help me? I cant figure out how to get a form to run off a query that searchs by partial field (like anything with "gum" in it). I am using this in my query criteria but after the prompt, no records come up.
Please help:
"*"&[Enter Key Word]&"*"

I believe that you need to include the phrase LIKE.

LIKE "*"&[Enter Key Word]&"*"

 

[cpinney1120]

Thank you - That was it! I just forgot the "like" - been about 7 years since i did this...