View Full Version : Solved: Access: Search Form

06-17-2005, 03:09 PM
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.


06-17-2005, 03:56 PM
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.

06-18-2005, 10:49 AM
Just use the form's requery method.

07-06-2005, 05:35 AM
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.

07-08-2005, 10:22 PM
Sonu, would you mark this thread as solved by using the link at the top of this window called "Thread Tools"?