[AccessD] SourceObject

Charlotte.... I wondered about that.  But --- my subreport control name is
subrptUPOHP.  If I select the SourceObject for the subreport control  in
Design mode (from the drop-down box), all available selections are prefixed
with "report."

Barb Ryan



----- Original Message ----- 
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Tuesday, January 04, 2005 12:55 PM
Subject: RE: [AccessD] SourceObject


> Hmmn.  I just realized that your subreport control and the name of the
> subreport object may not be the same.   What you want to pass as the
> sourceobject is the name of the subreport itself.  So if you need to
> resolve that from subreportcontrol.report.name, do it before you pass
> it.
>
> Charlotte Foust
>
>
> -----Original Message-----
> From: Charlotte Foust
> Sent: Tuesday, January 04, 2005 9:46 AM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] SourceObject
>
>
> I wouldn't have expected it to work in 97 either.  I believe it should
> be
>
> Me.subrptUPOHP.SourceObject = "subrptUPOHP" & strOption
>
> Charlotte Foust
>
>
> -----Original Message-----
> From: Barbara Ryan [mailto:BarbaraRyan at cox.net]
> Sent: Tuesday, January 04, 2005 9:43 AM
> To: Access List
> Subject: [AccessD] SourceObject
>
>
> After converting an Access 97 database to Access XP, I am encountering
> the following problem:
>
> A report ("rptUnionProposal") contains a subreport ("subrptUPOHP").
> There are several versions of this subreport (e.g., "subrptUPOHP",
> "subrptUPOHPA", "subrptUPOHPB", etc.).  In the Report Open event, I set
> the SourceObject for the subreport as follows:
>
> Me.subrptUPOHP.SourceObject = "report.subrptUPOHP" & strOption
>
> This has worked fine in Access 97.  In Access XP, however, I receive the
> error message - 3011 - the Microsoft Jet database could not find object
> "~sq_drptUnionProposal~sq_dsubrptUPOHP"
>
> Any ideas on what's happening?
>
> Thanks,
> Barb Ryan
> -- 
> 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