Query To Search Text String

[JeffGeorge]

I have created a form where a person can enter a text string. I want to use their input as the source for finding that string in a given field of a table. What would I use as the criteria for the associated query?

[kazaccess]

SQL for this:

SELECT *
FROM TableName
WHERE FieldName Like "*" & Forms![FormName]!TextBoxName & "*"

Replace the bold with your information
This will return all records with the text box value found anywhere in the field.

[JeffGeorge]

Great! I was trying to figure out how to incorporate the wildcard characters but couldn't quite figure it out. Thanks.