How to use wildcard query criteria with full object name?

[newyorkyankee]

I have a text box in a form and the query criteria is like this:

Like "[Forms]![frm_My_Form].[Controls]![txt_Word_Name]"

But it returns only the records that are identical to the text in the text field, and I want all the records that contain that word somewhere in the field, as when using the asterisk (*) wildcard enclosing the word. How to do it since it's not possible to use this wildcard in this expression? Here goes the SQL code of the query:

SELECT tbl_My_Table.[Item_ID], tbl_My_Table.[Item_Name]
FROM tbl_My_Table
WHERE (((tbl_My_Table.[Item_Name]) Like "[Forms]![frm_My_Form].[Controls]![txt_Word_Name]"));

[pbaldy]

Try

Like "*" & [Forms]![frm_My_Form].[Controls]![txt_Word_Name] & "*"

[newyorkyankee]

Excellent! Thank you pbaldy.

[pbaldy]

No problem!