Graph on form to report

[Guest]

Hi ! , I have a graph on a form that can change dynamically depending on
user's choice (data, chart type) This part is working good. I tried to
replicate the graph on the form in the report in vba but it's useless (can
not access the control property in report ) Is there a way to "copy and
paste" the graph control on the form to the report. Because of the special
formatting of the graph on the form, It's more then just changing the query
on the report's graph.
The control is MSGraph.Chart.8 and I'm using access 97 sr-2.
Thank's a lot !

 

[fredg]

Hi ! , I have a graph on a form that can change dynamically depending on
user's choice (data, chart type) This part is working good. I tried to
replicate the graph on the form in the report in vba but it's useless (can
not access the control property in report ) Is there a way to "copy and
paste" the graph control on the form to the report. Because of the special
formatting of the graph on the form, It's more then just changing the query
on the report's graph.
The control is MSGraph.Chart.8 and I'm using access 97 sr-2.
Thank's a lot !

Have you not tried it?

Frankly, creating the graph on the form and then copying and pasting
it onto the report is the best way top go.

In Form design view, click on the graph object (the OLEUnbound
control). Copy it. Open the Report in design View. Paste into the
report section you want the graph. The OLEUnbound record source will
paste along with the graph.