Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trouble setting row source of chart in report

Status
Not open for further replies.
bPruFin

bPruFin

Programmer
Sep 16, 2004
10
US
I'm using Access 2000.

In my Report_Open event I am trying to set the row source of a chart that I have on the report. Right now my chart (OLE Class: Microsoft Graph 2000 Chart) has the row source set statically in the properties box. However, I need to be able to set this dynamically.

When I try to do this using vba none of the options from intellisense are appropriate. I added ".rowsource" to after the object name but that just generates a run time error.

Any one have any ideas?

Thanks!
 
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Trying to Use Form Control as Variable in Report Control Source 2
Replies
5
Views
787
Andrzejek
Andrzejek
M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
4K
SoftwareRT
SoftwareRT
JimStrand
  • Locked
  • Question
Using Report Header (Form control) as Variable in Report Expression 1
Replies
11
Views
2K
dhookom
dhookom
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
1K
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Stop user changing size of Access Application (not form)
Replies
1
Views
778
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top