[AccessD] Sub Report Syntax...

My first reaction was there is a dot where a bang should be.
Not sure if it make a difference, though.

[Reports]![rpt_ProjectSummary].[rpt_TL1]![Report].Budget.Caption = sBudget

Note the bang between [rpt_TL1] and [Report].

Jim 
jhewson at nciinc.com 
  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paul Hartland
Sent: Friday, August 08, 2008 2:40 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
################################################################################

This email transmission contains information from NCI Information Systems, Inc. 
that may be considered privileged or confidential and is intended solely for the 
named recipient.  If you have received this message in error, please contact the 
sender immediately and be aware that the use, copying or dissemination of this 
information is prohibited.

################################################################################