Hey guys, i'm looking to run an access query and some how double click or select a row and push a button that will pull up a form that i created with that record loaded. Is there a way to do this?
-Shaunt
Queries don't have event's, and besides, you don't want to let your users have access to tables and queries, but forms.
This can easily be achieved in a continuous form with your current query as recorsource. Then create a button with something like this in the on click event procedure:
Use the name of the form you need to open, PKField, is the name of the primary key or unique field you filter on, and txtPKControl the name of the control on the current form holding this value.
BTW - Welcome to Tek-Tips!
To get the most out of the membership, take a look at this faq faq181-2886, and try to get familiar with the faq section and keyword search of the fora (see the tabs at the top of the page).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.