G
Guest
Used the instructions here:
http://office.microsoft.com/en-us/assistance/HA011170771033.aspx
to create a report that uses a form to feed parameters to a query that
outputs a report. Here's how it works:
-You open the report.
-Access processes the code attached to the report's Open event.
-That code opens a form that serves to collect the parameters.
-You enter the parameters and click OK.
-Access hides the form, but the form does not close.
-Access then processes the report's underlying query.
-That query retrieves parameters from the controls on the form that is
currently hidden, does its work, and then delivers its results to the report.
-The report finishes, and displays its results.
-When you close the report, code in the report's Close event also closes the
hidden form.
My issue is that the underlying query stays open after closing the report.
What do I need to do to have query close as well?
http://office.microsoft.com/en-us/assistance/HA011170771033.aspx
to create a report that uses a form to feed parameters to a query that
outputs a report. Here's how it works:
-You open the report.
-Access processes the code attached to the report's Open event.
-That code opens a form that serves to collect the parameters.
-You enter the parameters and click OK.
-Access hides the form, but the form does not close.
-Access then processes the report's underlying query.
-That query retrieves parameters from the controls on the form that is
currently hidden, does its work, and then delivers its results to the report.
-The report finishes, and displays its results.
-When you close the report, code in the report's Close event also closes the
hidden form.
My issue is that the underlying query stays open after closing the report.
What do I need to do to have query close as well?