• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 169
  • Last Modified:

Using Input Form to Run Multiple Reports

I have created an input form which has the following fields: start date and end date.  These are the parameters for the reports.  My problem is that I have seven different reports using this same form.

My question is how do I go from this form to the specific report I want?  I know that I could make seven different dialog boxes for each report but this is time consuming and cumbersome.

Any help would be appreciated.
1 Solution
Unless you are using macros you probably already have code to print each report. Create a subroutine in a module that includes the code for your input box and your print report code. Pass the subroutine the name of the report you want to print and refer to this in the docmd.openreport statement.
public sub testprint(strReportname as string)

'inputbox code here

DoCmd.OpenReport strReportName ,,"[startdate]=" & inputStart & " AND [enddate]=" & inputEnd  'or whatever code you are using for your existing report

end sub
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now