[AccessD] Graph Rowsource

Thanks Jim,

I am starting to think that if I can't pass a parameter to the graph's 
rowsource then I will need to go your suggested way and create a table 
before running the report which has the data in it.

David

At 27/06/2005, you wrote:
>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/0311UnboundReports.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?