RANDALL R ANTHONY
RRANTHON at sentara.com
Tue Sep 1 14:38:09 CDT 2009
..slowly banging head on desk... D'OH! I cut and paste haphazardly, Doug was spot on. Thanks everyone, I think I'll just go play some golf now... >>> On 9/1/2009 at 3:27 PM, in message <B4F1446167F0BD4FAD640A79824EE0B00E1A51F045 at LIVP3MMBX11.mail.aig.net>, "Heenan, Lambert" <Lambert.Heenan at chartisinsurance.com> wrote: 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 ( http://www.databaseadvisors.com/ ) -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ( http://www.databaseadvisors.com/ ) -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ( http://www.databaseadvisors.com/ )