Using wildcards in a query referencing a text box

[kazaccess]

I have a form that opens up a query. The form has a text box where the user can type a name. If possible in the query editor, how would I go about this? For example, if the user types 'John', I would like the query to return the same as: Select * From Table Where Name Like %'John'%
I have tried several variations of: WHERE Name LIKE %Forms![MyForm]!Name%, but with no luck. Any ideas?

 

[dhookom]

I assume "Name" is a place holder and not a real field or control name. "Name" is a reserved word and should never be used to name anything.

WHERE [Name] LIKE "*" & Forms![MyForm]![Name] & "*"

Duane
Hook'D on Access
MS Access MVP

 

[kazaccess]

Perfect!Thank you so much. And, yes, "Name" was just a place holder so I could give a simple example.