I need to set the RowSource property in VBA code and have seen in MS Knowledgebase Article 209993 sample code for doing so:
"Reports!ReportName!ChartName.RowSource = " SELECT Blah Blah etc ;"
When I run the code I get "Run-time error '2455', You entered an expression that has an invalid reference to the property RowSource" .
What should be a simple and routine matter is simply not working as Bill says it should.
Help Please.
Ronald A. Wellman
Omega Systems Analyst
University of Rochester
Laboratory for Laser Energetics
Room 290B
250 E. River Rd.
Rochester NY 14623-1299
Phone: 585.275.9479
Mailto:rwel@lle.rochester.edu
"Reports!ReportName!ChartName.RowSource = " SELECT Blah Blah etc ;"
When I run the code I get "Run-time error '2455', You entered an expression that has an invalid reference to the property RowSource" .
What should be a simple and routine matter is simply not working as Bill says it should.
Help Please.
Ronald A. Wellman
Omega Systems Analyst
University of Rochester
Laboratory for Laser Energetics
Room 290B
250 E. River Rd.
Rochester NY 14623-1299
Phone: 585.275.9479
Mailto:rwel@lle.rochester.edu