>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
How big is the table you are wanting to search?
The reason I ask is that contains searches are not very fast (at least I have not found them to be) on large tables.
So to move the file as they type and do a contains search may be somewhat chunky in how fast it returns.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope