Query from Textbox??

[mike]

Hi all,

How do you run a query from the text box and return the
value from the table.

I have a text box, call username and when the text box
gets its focus, it will run the query.

The code is:

Private Sub username_GotFocus()

Dim strName As String

strName=...

End Sub

The strName get the data from the user table and return
only the name base on ,let say mike, and set the username
to strName. Any suggestion on how to do that or Is it
possible??

Thanks for the help...

mike