I want to create a from in Access with a text box where I can put in a value and then when I click the button it would query the table and bring the results in the same form and populate results in different text boxes that I already have on the form. I have a query and its results show up in the form but only when that form is opened up. I could not figure out how can I make the query result show up in the same form which is already open.

Any help is really appreciated.

Regards
sonu