If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: On change event and requery form

I have a form (continuous form) and at the top of the form is a textbox that after I type any number of characters - I click a search button and then the code builds a sql statement using the contents of the textbox as "like" statements across multiple columns to
return any matching records by resetting the recordsource to the sql statement and requerying

It works fine but I have to click the search button to see the results

How can I use the change event to build and run the query as I type the characters - like a "real-time" search as I type?