Printable View
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:think:
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.
Just use the form's requery method.
I was able to do that by using list box rather than text box.
Thanks for the help.
Quote:
Originally Posted by OBP
Sonu, would you mark this thread as solved by using the link at the top of this window called "Thread Tools"?