event procedure for requery

[Guest]

I have a search field control for a query used by my form - I use it to
display only names greater than or = to what is entered in the text search
field control. It works great when the event procedure is invoked via the
After Change property for the control where the text is entered. But I have
to hit enter or tab to the next field. My goal is to invoke the requery
after every keystroke so that the list of names displayed is constantly being
refreshed based on the search criteria text being entered in the search
control. The text entered does not seem to be available to me in the event
procedure when I use the On Key Down property for example. Any suggestions
on how to accomplish this?

Thanks.

 

[Arvin Meyer [MVP]]

You don't say which version of Access you are using, but the demo below
ought give you enough information to get you going.

http://www.datastrat.com/Download/ExpandingSearch2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access