Problem with using stored procedure with an Access 2002 report

D

Doug

I have a stored procedure that accepts a number of parameters. In the onOpen
event of my report I set the me.recordsource = me.openargs. The me.openArgs
contains the following statement:

exec spApptsByMthTEG @syear = '2004',@iclientcode = 7471

When I execute the report I get Run-time error 5: Provider command for child
rowset does not produce a rowset. It seems to work fine when me.openargs
only has one parameter such as: exec spApptsByMthTEG @syear = '2004'

If I execute the contents of me.openargs in Query Analyzer it works great.

I would really appreciate any help you can give me.

Thanks,
Doug
 
Top