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!

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

RowSource Madness - Property doesn't exist?? (sorry for dupe)

Status
Not open for further replies.

Jucius

Technical User
Aug 9, 2002
25
CA
(I apologise for posting this elsewhere - I didn't realise that there were a whole bunch of MSAccess sub-forums at first.)

The code is like this:
Code:
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?
 
What is this
[ChartOLEUnbound]
and how does it relate to the Report?
 
I thought [ChartOLEUnbound] was self explanatory - it's a chart in the report created by the chart wizard. I'm trying to manipulate it's RowSource property through VBA.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top