[AccessD] Graph Rowsource

Running with this idea, how do I pass a parameter to the sproc.  In the 
recordsource I have:

EXEC dbo.sprptIncomeNeedsChart ClientIDNo

but it seems to be treating the field (ClientIDNo) as a varchar value 
('ClientIDNo'), not an integer (which the value is)

I can't include the ClientIDNo field in the sproc and use child and master 
fields because I can't work out how not to include that field in the data 
being used in the graph itself.

Here is the main part of the sproc:

SELECT C1stName, CDisIncome AS [Required Funds], CDisIncP + CDisLumpSum + 
CDisSuper + CDisOtherInc AS [Available Funds]
FROM vwCashManagement
WHERE ClientIDNo = @txtClientIDNo
UNION SELECT P1stName, PDisIncome AS [Required Funds], PDisIncC + 
PDisLumpSum + PDisSuper + PDisOtherInc AS [Available Funds]
FROM vwCashManagement
WHERE ClientIDNo = @txtClientIDNo


David

At 27/06/2005, you wrote:
>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
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com