Use Parameter Form to export a query

  • Thread starter Thread starter TraciAnn
  • Start date Start date
T

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?
 
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.
 
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!
 
You can't.

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