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?

[kazaccess]

Solved. If you are curious for your own purposes: WHERE [Name] LIKE "*" & Forms![MyForm]![Name] & "*"
I didn't realize the "*" could be used in this case.

[pbaldy]

Thanks for posting your solution. FYI, as a general rule JET/ACE and DAO use *, ADO uses %.