Manipulate Access Reports from VB

[rann]

Hi,
How can i manipulate an Access Report from VB.

For example i have a MS Chart Control on my Access Report.
I need to manipulate it from VB so that the user can select the graph type to be displayed (Line, Bar or Pie graph).

I do this in regular local code as
myMSChart.chartType = VtChChartType2dBar

I was using the below to open an Access Report .
Dim objAccess As Object
Set objAccess = CreateObject("Access.Application&quot
With objAccess
.OpenCurrentDatabase filepath:=dbname
.DoCmd.OpenReport reportname:=rptname
End With


how can this be done.

Any help or links would be appreciated,

Thanks in Advance.

Rann.