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?
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?
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.
Great! I was trying to figure out how to incorporate the wildcard characters but couldn't quite figure it out. Thanks.