[AccessD] Sub Report Syntax...

Paul Hartland paul.hartland at googlemail.com
Fri Aug 8 01:38:58 CDT 2008


Darryl,

Just off top of my head, can't you put the code into the actual sub-report
on format function (think it's called format, only don't have a machine with
Access on at the moment) then just have [reportname].labelname.caption =
sBudget

Paul

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

> 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
>



-- 
Paul Hartland
paul.hartland at googlemail.com



More information about the AccessD mailing list