Max Wanadoo
max.wanadoo at gmail.com
Tue Sep 1 14:36:45 CDT 2009
Then open the report and look at the properties page to see what the filter is set to. As long as you don't click on it, it will show you. You can then try to open the recordset with the same filter and see what happens. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: 01 September 2009 20:28 To: 'Access Developers discussion and problem solving' Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com