Text Box Change Event

Hi All,
I am trying to run code that I have assigned to a button on an MSAccess form. The code creates an SQL statement which searches the database for an address. I want to run the code when the user clicks the button but also, when the user changes the value of a specific text box on the form. I want it to run every time the user puts a new value in the text box.  For example, the user types in "1" and the code runs and returns all the records containing a "1".  The user then types in a "2', and the code runs and returns all teh records container a "12" and so on.  The problem that I am having is, when the user types a "1" and the text box Change event fires, the text box value is still "null".  However, if I exit the text box and manually click the button, the value is exposed.  I have tried refreshing the form prior to running the code and that works however, it sets the focus back on the text box and highlights all the information contained with in it and will not allow for users to enter spaces in the text string.  Anyone have any suggestions?

Sample code would look something like this:

Private sub button1_click()
    'run code
    Dim strValue as string
    strValue = me.textbox
End sub

Private sub textbox_Change()
   button1_click
End sub

When the button is clicked, strValue reads the value from the text box
When the textbox_Change event is fired, strValue is null
I need to populate strValue.

Any help is appreciated and Thanks in advanceStart Free Trial