How to Query part of a field

[JavaTurkey]

It's simple, but it ain't working.
I want to run a query on a table, based on input from a form. The part I can't get to work is I need it to query ANY part of the field. ie--> if I put "ll", it will bring up records containing Hello, Yellow, Hollow, etc. In the criteria for the query, I try

Like *[Forms]![Form1]![EnterMe]*
and
Like "*"[Forms]![Form1]![EnterMe]"*"

nothing works. If I just enter the string, it works fine (but queries the entire field) Am I missing a " or a () or something? thanks....

 

[TerpFan2001]

Java:

You will need to add & around the the formfield. Also, add .[Text] like so:

Like "*" & [Forms]![Form1]![EnterMe].[Text] & "*"

 

[Aivars]

If you create query you may write:

Like "*" & [Forms]![Form1]![EnterMe] & "*"

Aivars

 

[JavaTurkey]

worked like a charm. thanks Terp.