Solved

Using Input Form to Run Multiple Reports

Posted on 1998-06-15
1
157 Views
Last Modified: 2008-07-03
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.
0
Comment
Question by:ecohouse
1 Comment
 
LVL 8

Accepted Solution

by:
Helicopter earned 50 total points
ID: 1975407
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.
e.g.
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
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now