Hi there,
The way I tackle this is to first create a SQL statement as a string and add the textbox value to that SQL string. If you aren't great with SQL, you can get the SQL string by creating a query and changing to SQL view, then lastly tweak the SQL to include the TextBox value.
so...