Using a text box for the user to input a search string, I want to run a query as they type against a table looking the string they have typed anywhere in the field, not just the starting with. Normally, all my searches use a grid with the ingrid, but to my knowledge I can't do a contains with that search.

So, if anyone could help, here is what I need. First I'm not sure the the SQL-Select syntax for using the contains. Second, I would like the query to run as they type each letter in the text box, and I'm not sure if I should do this from the Interactive Change or the Keyboard method.

Thanks for you help

Kirk