Printing charts With Parameter Query

Johnnyw

Registered User.
Local time
Today, 12:29
Joined
Feb 19, 2001
Messages
13
I have charts linked to queries that have parameters set for the date Between[Enter Start Date] and [Enter End Date]. When I try to print multiple copies of the chart, I have to enter the parameters for the date multiple times. I want it to just ask once and print as many copies as I want.
 
Put the start and end dates as text boxes on a form. Use a command button to open the charts, and use the text boxes as criteria in the queries that provide the data for the charts. Each time the dates are needed, they will be plucked from the form.
 

Users who are viewing this thread

Back
Top Bottom