[AccessD] Passing OpenArgs to Subreport

Just type ? AccessError(2491) in the immediate window to find out.

But as Doug has pointed out, the problem is that the parameter is being passed in via the Filter parameter not the OpenArgs one for the OpenReport method.

Lambert 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Tuesday, September 01, 2009 3:23 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Passing OpenArgs to Subreport

I don't know what the 2491 error is ???

Have you put some code in the report to trap the openargs value to inspect it?

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of RANDALL R ANTHONY
Sent: 01 September 2009 20:08
To: accessd at databaseadvisors.com
Subject: [AccessD] Passing OpenArgs to Subreport

Howdy peeps,
Probably simple answer but I can't find anything to specifically to solve my problem, could it be one of those can't get there from here?
 
A2003.
 
DoCmd.OpenReport sObjName, acPreview, strSvcRegion & "~" & strLocality
 
When it hits the main report, which is just a shell with three subreports, I get the 2491 error.
 
I've created a label to hold the openargs string, but it doesn't even get there.  I've tried a couple other things but that just results in the openargs value in the main report to be null.  I'm trying to pass report labels to the subreport.
 
TIA.
--
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