[AccessD] Sub Report Syntax...

Could you not put a similar line of code, in the report open event of the
sub report ?

2008/8/8 Darryl Collins <Darryl.Collins at coles.com.au>

>
> 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.Caption = 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
>



-- 
Paul Hartland
paul.hartland at googlemail.com