(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:
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?
The code is like this:
Code:
Private Sub Report_Open(Cancel As Integer)
Me.[ChartOLEUnbound].[RowSource] = "Select ... "
End Sub
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?