Access Wildcard Help

Alrighty I've looked through the archives but didn't see this, forgive me if I just plain missed it.

I'm trying to just do a query in access which searches a column for the string entered (user inputted upon execution). I've got that much done. However, it will only match it exactly to what you've typed. I want it to have a wildcard before and after whatever the user has inputted.

WHERE ((([Application Information].TxtAppName) Like [Enter Application Name] ));

thats my where clause right now. I've tried something like

WHERE ((([Application Information].TxtAppName) Like %[Enter Application Name]% ));

but that doesn't work. I'm still a newbie to access query syntax so forgive the simple question.

Thanks in advance.

Ha, just found my own answer... sheesh.

If you know of a cleaner way by all means post it but just FYI.

WHERE ((([Application Information].TxtAppName) Like '*' & [Enter Application Name] &'*' ));

that will match whatever was entered to anything that contains the string in that column.