Use Parameter Form to export a query

[TraciAnn]

I just recently tackled the challenge of creating a form with fields that
provide the parameters to queries when running a report. The form is called
from the Open property of the report and the form fields are named in the
queries that populate the report.

I would like to use the same concept for a query that is only used to export
the data to an Excel Spreadsheet - there is no report in the process to call
a form to enter parameters.

Can this be done?

 

[Douglas J. Steele]

Sure. You already know how to create a query that gets its parameter values
from a form. Just export that query, rather than extracting the table.

 

[TraciAnn]

But how do you get the query to call the form? A report has events which
calls the form on open and exits the form on close. I need the same type of
effect for the export.

Thanks!

 

[Douglas J. Steele]

You can't.

The form must be open before the query's run. Put a button on the form that
runs the export.