Parameter Report

  • Thread starter Thread starter Joe Schmo
  • Start date Start date
J

Joe Schmo

Is there a way to open a dialog box to prompt a filter for a report ...
similiar to a parameter query

Thanks
 
Is there a way to open a dialog box to prompt a filter for a report ...
similiar to a parameter query

Thanks
Click to expand...

You can adapt this.

Create an unbound form.

Add 2 unbound text controls.
Set their format to a valid date format.
Name them "StartDate" and "EndDate"

Add a Command Button to the form.
Code the button's click event:

Me.Visible = False

Name this form 'ParamForm'.

In the query that is the Report's Record Source, as criteria on the
date field write:

Between forms!Paramform!StartDate and forms!ParamForm!EndDate

Next, code the report's Open event:
DoCmd.OpenForm "ParamForm", , , , , acDialog

Code the report's Close event:
DoCmd.Close acForm, "ParamForm"

When ready to run the report, open the report.
The form will open and wait for the entry of the starting and ending
dates wanted.
Click the command button and then report will run.
When the report closes, it will close the form.
 
Back
Top