Set Chart RowSource programmatically.

[Alan Z. Scharf]

Hi,
I want to set the RowSource of an MS Graph pie chart on Access 2003 form
programmatically.

What is the syntac for that?

I got as far as : "With
Forms!frmTestForm![TestChart].Object.Application.Chart ......"

In Excel, it would be: " ActiveChart.SetSourceData Source:=Sheets("Pie
Chart").Range("A6:B9"), PlotBy _
:=xlColumns"

However, I'm having trouble translating that to Access form.

Thanks.

Alan

 

[Duane Hookom]

If the code is running in the form that contains the chart, just set the Row
Source property of the chart control:

Me.objChartControl.RowSource = "SELECT...."

 

[Alan Z. Scharf]

Duane,

Thanks once again.

Alan

If the code is running in the form that contains the chart, just set the Row
Source property of the chart control:

Me.objChartControl.RowSource = "SELECT...."

--
Duane Hookom
MS Access MVP

Hi,
I want to set the RowSource of an MS Graph pie chart on Access 2003 form
programmatically.

What is the syntac for that?

I got as far as : "With
Forms!frmTestForm![TestChart].Object.Application.Chart ......"

In Excel, it would be: " ActiveChart.SetSourceData Source:=Sheets("Pie
Chart").Range("A6:B9"), PlotBy _
:=xlColumns"

However, I'm having trouble translating that to Access form.

Thanks.

Alan