[AccessD] SourceObject

Charlotte Foust cfoust at infostatsystems.com
Tue Jan 4 11:55:05 CST 2005


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



More information about the AccessD mailing list