Display Chart Report on Form 1

[dbero]

I would like to display a chart/graph from a report on a form rather than having it open independently. I have been playing with the Pivot Chart form, but that typically ends badly after I move the pivot fields around. I just want a fixed report to display on a form, then be replaced with another report as the user decides.

Any suggestions to effectively display graphs within a form?

thank you

 

[dhookom]

Have you tried copying the chart control from the report to the form? When creating charts for reports, I generally begin by creating the chart on a form. When I have this looking as desired, I copy and paste it to my report.

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]

 

[dbero]

that's very close, however i would like to have control over the report that is displayed. is it possiblee to hide the first chart, and replace it with a different chart in the same location?

 

[dhookom]

You can set controls' visible property to hide/display any 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]