[AccessD] Sub Report Syntax...

Hi Jim

That could be it, but then it should read:

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

/gustav


>>> JHewson at nciinc.com 08-08-2008 15:07 >>>
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.