djrock,
You don't need a query.
' ***********************************
Me.RecordSource = "select * " & _
"From MyTable " & _
"Where MyKey = '" & Me.MyTextBox & "'"
Me.Requery
Me.Refresh
' ***********************************
Just Change MyTable to the name of your Table
MyKey to the Table's field that matches your TextBox
Me.MyTextBox to the name of your textbox.
Now, you could use a query. That query would be the form's
recordsource. It would have, in the criteria field, for the field
that matches your textbox, =Forms![YourForm]!YourTextBox
Either one way or the other, not both!
Wayne