[AccessD] Graph Rowsource

Hi David:

You may have a look at an article posted to DBA site that deals specifically
with changing report data source on the fly. Some of the information may be
helpful:
http://www.databaseadvisors.com/newsletters/newsletter112003/0311UnboundRepo
rts.htm

HTH
Jim

-----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