RowSource Madness - Property doesn't exist??

[Jucius]

(I posted this in some other section here, but I think that this is a more appropriate part of the forum)

I am attempting to use VBA to change the RowSource property on a chart in a report.

The code is like this:

Private Sub Report_Open(Cancel As Integer) 

Me.[ChartOLEUnbound].[RowSource] = "Select ... "

End Sub

I am 100% sure that the SQL code is correct and I have tested it in other queries.

The program complains that there is no such property as RowSource, but it does exist -- it can be easily modified through the property menu!

The error: Runtime error '2455' - You entered an expression that has an invalid reference to the property RowSource. The property may not exist or may not apply to the object your specified.

How do I use RowSource in VBA?

 

[CosmoKramer]

See if RecordSource works instead.....

 

[Jucius]

I've tried Recordsource and RowSource and neither of them worked ... any more ideas?

 

[Rauken]

I need help on this too. It works in forms but it doesn't seem to work in reports!

 

[Rauken]

http://support.microsoft.com/?kbid=209993

Crazy solution!!