referencing subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lorenzo - 04 May 2005 06:36 GMT

I have a subform within a subform within a subform (yes thats right 3 levels
deep)
From my first form I wish to reference the subform at third level down.
So for arguement sake we will call the first form "Form1" the second form
"SubForm2" and the third form "Subform3"

From Form1 I want to reference SubForm3 so how would I do this?

Reply to this Message

Marshall Barton - 04 May 2005 14:46 GMT

>I have a subform within a subform within a subform (yes thats right 3 levels
>deep)
[quoted text clipped - 3 lines]
>
>From Form1 I want to reference SubForm3 so how would I do this?

It depends on what level the reference is in, but in
general, use this sort of logic:

In the main form:
Me.subform1.Form.subform2.Form.subform3.Form.textbox

In the subform1:
Me.subform2.Form.subform3.Form.textbox

and so on.

Note that subformN is the name of the subform **control** on
its container form. The subform control name may be
different from the name of the form displayed in the subform
control.

Signature

Marsh
MVP [MS Access]

Reply to this Message