refer to control in subform in subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Henrootje - 16 May 2007 12:50 GMT

I have a dream!

But I also have a report.......

That report has a subreport with a subreport. With the following code
I change the caption of a label.

dim d as string
d = "hello world"
Reports!rpt_CG_Creditgeld!rpt_CG_SubRapportComp!Sub362!lbl1.Caption =
d

Now I want to do the same thing, using the same reports, but the only
difference is the mainreport:

it is called rpt_CG_Creditgeld_CL instead of rpt_CG_Creditgeld

But where
Reports!rpt_CG_Creditgeld!rpt_CG_SubRapportComp!Sub362!lbl1.Caption =
d
works,
Reports!rpt_CG_Creditgeld_CL!rpt_CG_SubRapportComp!Sub362!lbl1.Caption
= d
does not...............
Any of these reports are open at the same time, what might be causing
the Error 2455 ?
AFAIK that means something wrong in the syntax or spelling of the
referral but I can not find it?

Any of you has any ideas?

Reply to this Message

Arvin Meyer [MVP] - 16 May 2007 15:26 GMT

The syntax is:

A = Main report
B = subreport
C = nested subreport (in B)

Reports!A!B.Report!C.Report!LabelName = "Whatever"

adding extra spaces for clarity:

Reports ! A ! B . Report ! C . Report ! LabelName = "Whatever"

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> I have a dream!
>
[quoted text clipped - 26 lines]
>
> Any of you has any ideas?

Reply to this Message

Henrootje - 17 May 2007 18:48 GMT

Arvin,

I had found the right syntax but apparantly things will not work if
you mix reports and forms.........................

I saved the subforms as reports and using your syntax things started
working!

Thnx for thinking

Henro

> The syntax is:
>
[quoted text clipped - 40 lines]
>
> > Any of you has any ideas?

Reply to this Message