Chart in Report

  • Thread starter Thread starter Sue B.
  • Start date Start date
S

Sue B.

My chart in a report asks for parameters when trying to
print. The report by itself does not do this. The
parameters are passed by a form. The report and chart have
the same data source, a parameter query. The report
preview displays, but when attempting to print it asks for
the parameters again.
 
My chart in a report asks for parameters when trying to
print. The report by itself does not do this. The
parameters are passed by a form. The report and chart have
the same data source, a parameter query. The report
preview displays, but when attempting to print it asks for
the parameters again.
Click to expand...

Make sure the form remains open while the report is run.
The usual method of using a form for parameter entry is to open it
from the Report's Open event:
DoCmd.OpenForm "FormName", , , , , acDialog
Then close it in the report's Close event:
DoCmd.Close acForm,"FormName"
You'll need a command button on the form to hide the form:
Me.Visible = False
after the parameters have been entered.
 
Thank you Fred! That is true, the form needs to be open
for the chart to read the parameters it supplies :) Also
helpful from a post I found through search (Duane Hookom).
He suggested putting the parameters in the row/source
query as they appear in the original query. Thanks to all!
 
Back
Top