How to reference label in partent subform?

[Bazsl]

I have form A which contains subform B which contains subform C. From code in subform C I need to set the caption of a label in subform B.



Forms![B].[CostumeDescriptionLabel].Caption = rst!Description

generates the error "3265 Item not found in this collection". What is the right way to reference a component in the parent subform from the child subform? Thanks.

[aytee111]

Forms![A]![B]..... Form B is part of form A, it is not a standalone form.

[Bazsl]

I still get the same error. If I try

f = Forms![Checkout]![Checkout Event Subform]![CostumeDescriptionLabel]

I get "Error 438. Object doesn't support this property or method." However, if I shorten the above to

f = Forms![Checkout]![Checkout Event Subform]

I do not get an error. There is a Label control on the subform named [CostumeDescriptionLabel].

My goal is to set the Caption property of the label but I still cannot get the syntax right. Thanks for your help.

[aytee111]

In your first post you were giving it a value, in your second that had all changed?

[Micron]

I've never nested subforms, but try

[Forms]![Main form name]![subformA control name].[Form]![subformB control name].[Form]![Label Name].Caption

where subform control name is the name of the control that contains the subform - it is not the subform name (although you might have allowed a wizard to have both objects with the same name, which is not a great idea).

If you're using this in vba, consider creating a control object and setting this syntax to it if you're going to use it more than once. Like
Dim ctl As Control
Set ctl = ......
ctl.Caption = rst!Description