[AccessD] Graph Rowsource

Why don't you make the row source a Stored Procedure (sproc) and have the
sproc do the correct SELECT for you? That way you don't need to anything
fancy in the FE. I tend to not give users select rights to tables and make
everything sproc driven.

D

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of David Emerson
Sent: Sunday, June 26, 2005 7:44 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Graph Rowsource


AccessXP ADP,  SQL2000

I am trying to change a graphs rowsource via VBA.   When I have the
following in the Detail_Format section of the report -

     Me!chtincNeeds.RowSource = "SELECT C1stName ...  " (Rest of query
omitted)

I get an error 2191 - You can't set the rowsource property in print preview
or after printing has started.

If I put it on the report's on open event I get error 2455 - You entered an
expression that has an invalid reference to the property RowSource.

How can I dinamically change the rowsource?

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com