Solved: Access: Search Form

[sonu]

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

[xCav8r]

Easiest way is to put the text box on a main form, binding the value in the text box to a key or an index you can use to return the row in the query that you want to use to populate information on your form. You'll need to create a subform for the returned data, and link the form and subform with the aforementioned field.

[OBP]

Just use the form's requery method.

[sonu]

I was able to do that by using list box rather than text box.

Thanks for the help.

Just use the form's requery method.

[xCav8r]

Sonu, would you mark this thread as solved by using the link at the top of this window called "Thread Tools"?