How do I refer to a series on an MSgraph in access?

[ian.davies52]

I have an msgraph on a form. The chart has five series on it. On the
same form I have five checkboxes. I'm trying to make it so that
checking/unchecking a checkbox will result in each of the series on the
chart being shown/hidden. I keep getting "object does not support
method" error.

I'm trying code like:

Set cht = Me.scoreHandicapChart.object.seriescollection(1)
cht.series.showline = false

I've done this in Excel, but why doesn't Access work the same way?

Thanks

[ian.davies52]

In case anyone else is having a problem like this, I figured out that I
needed to add the MS graph reference (done from VB->Tools menu) and
then used the following code:

Function showOrHideChartLines(tickbox As Boolean, seriesIndex As
Integer,_ colorNumber As Integer)

Dim cht As Graph.Chart

Set cht = Me.Chart1.Object

If tickbox = False Then
cht.SeriesCollection(seriesIndex).Border.ColorInde x =
xlColorIndexNone
cht.SeriesCollection(seriesIndex).MarkerStyle =
xlMarkerStyleNone
If seriesIndex = 1 Then
cht.SeriesCollection(seriesIndex).Trendlines(1).De lete
End If
Else
cht.SeriesCollection(seriesIndex).Border.ColorInde x =
colorNumber
cht.SeriesCollection(seriesIndex).Border.Weight = xlMedium
cht.SeriesCollection(seriesIndex).MarkerStyle =
xlMarkerStylePlus
cht.SeriesCollection(seriesIndex).MarkerForeground ColorIndex =
colorNumber
cht.SeriesCollection(seriesIndex).MarkerBackground ColorIndex =
xlColorIndexNone
If seriesIndex = 1 Then
cht.SeriesCollection(seriesIndex).Trendlines.Add
cht.SeriesCollection(seriesIndex).Trendlines(1).Ty pe =
xlPolynomial
cht.SeriesCollection(seriesIndex).Trendlines(1).Or der = 4

cht.SeriesCollection(seriesIndex).Trendlines(1).Bo rder.ColorIndex = 8
End If
End If
end function