Refer to a control on a subform

[Sarah]

I have a tab control which displays a subform on Page 1 and a subform on Page
2. On Page 1, I would like to reference a control from the subform on Page 2.

Does anyone know how to do this? This is what I tried and it doesn't work:

[forms]![MainForm]![subfrm2].[form]![ctrl2]

I can reference control ctrl2 from the MainForm, but not from subfrm1.

Any help would be appreciated. Thanks,

Sarah

 

[Douglas J Steele]

I'm confused as to where you're trying to reference this control from.

If you're trying to reference it from the subform on page 2 itself, you can
simply use Me![ctrl2]

If you're trying to reference from the subform on page 1, try
Me.Parent![subfrm2].[form]![ctrl2]

If you're trying to reference it from the main form, what you've got should
do it.

 

[Sarah]

Thank you!!!!!!

I'm confused as to where you're trying to reference this control from.

If you're trying to reference it from the subform on page 2 itself, you can
simply use Me![ctrl2]

If you're trying to reference from the subform on page 1, try
Me.Parent![subfrm2].[form]![ctrl2]

If you're trying to reference it from the main form, what you've got should
do it.


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have a tab control which displays a subform on Page 1 and a subform on Page
2. On Page 1, I would like to reference a control from the subform on Page 2.

Does anyone know how to do this? This is what I tried and it doesn't work:

[forms]![MainForm]![subfrm2].[form]![ctrl2]

I can reference control ctrl2 from the MainForm, but not from subfrm1.

Any help would be appreciated. Thanks,

Sarah