[AccessD] Sub Report Syntax...

Hi Darryl
Firstly is rpt_TL1 the name of the sub-report control, not its report name?
I'm guessing yes, in which case I reckon the syntax is fine and I think it
will work fine if you just move it. I've had this before where if you run
code like this from the form's OnOpen it's like other controls don't yet
exist. Do you have a Report Header? Move the code to the OnFormat of that. I
think the code will work fine if fired later.

-- Andy Lacey
http://www.minstersystems.co.uk 

>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com 
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
>Darryl Collins
>Sent: 08 August 2008 07:47
>To: 'Access Developers discussion and problem solving'
>Subject: Re: [AccessD] Sub Report Syntax...
>
>
>
>I should have mentioned that the code resides in a Module that 
>is being called as part of the Report Open Event...
>
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of 
>Darryl Collins
>Sent: Friday, 8 August 2008 4:31 PM
>To: 'Access Developers discussion and problem solving'
>Subject: [AccessD] Sub Report Syntax...
>
>
>Hi all,
>
>A dead easy one I am sure, but got a bad case of fried brain 
>this friday afternoon.  What is up with this syntax...
>
>[Reports]![rpt_ProjectSummary].[rpt_TL1].[Report].Budget.Captio
>n = sBudget
>
>is returning "Invalide Ref to Property Form/Report", which 
>would suggest a spelling or naming error, but I check that 
>about 20 times already.  Or do have the syntax all buggered 
>for the subreport.
>
>I want to write the value of the string "sBudget" into a label 
>(named budget) on the subreport.  Can be that hard surely!!??
>:)
>
>cheers
>Darryl.
>
>This email and any attachments may contain privileged and 
>confidential information and are intended for the named 
>addressee only. If you have received this e-mail in error, 
>please notify the sender and delete this e-mail immediately. 
>Any confidentiality, privilege or copyright is not waived or 
>lost because this e-mail has been sent to you in error. It is 
>your responsibility to check this e-mail and any attachments 
>for viruses.  No warranty is made that this material is free 
>from computer virus or any other defect or error.  Any 
>loss/damage incurred by using this material is not the 
>sender's responsibility.  The sender's entire liability will 
>be limited to resupplying the material.
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com 
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>This email and any attachments may contain privileged and 
>confidential information and are intended for the named 
>addressee only. If you have received this e-mail in error, 
>please notify the sender and delete this e-mail immediately. 
>Any confidentiality, privilege or copyright is not waived or 
>lost because this e-mail has been sent to you in error. It is 
>your responsibility to check this e-mail and any attachments 
>for viruses.  No warranty is made that this material is free 
>from computer virus or any other defect or error.  Any 
>loss/damage incurred by using this material is not the 
>sender's responsibility.  The sender's entire liability will 
>be limited to resupplying the material.
>
>
>-- 
>AccessD mailing list
>AccessD at databaseadvisors.com 
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>