Printing a chart without re-entering parameters

[VRoscioli]

I have a report in Access 2003 that was created with the Chart Wizard. The data source for the chart is a query that requires several parameters. When I attempt to view the report, it asks for the parameters (as expected) and displays normally. However, if I then try to print the chart, it asks for a new set of parameters. Is it possible to have it not ask for new parameters and instead use the old ones?

Thanks.


-V

 

[dhookom]

IMHO, parameter prompts are not acceptable user interface. They should be replaced by references to controls on forms. This allows you to use combo boxes, calendar controls, default values, ... Plus, you don't have to enter them multiple times when once will do ;-)

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[VRoscioli]

The client whose database I am adding this report to is used to the parameter prompts and does not want a separate user interface.


-V

 

[dhookom]

I guess it's not up to me if you want multiple prompts for the same information. That's what happens with parameter prompts. They aren't stored anywhere so you keep having to remind the chart/report/subreport/... what you are using for a criteria.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[VRoscioli]

While this is true, printing regular reports with parameter prompts does not require re-entry of the parameters to print the report, so I was just wondering if there was a way to do this with the chart as well.


-V

 

[dhookom]

A regular report with subreports would require re-entering of parameters from the subreport record source. This is very similar to the Row Source of a chart control.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]