I have a text box in a form and the query criteria is like this:
Code:
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:
Code:
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]"));