Change Caption on Another Form with VBA

[bstice]

Hello all,

I am interested in learning the VBA code that I need to write to change the caption of a label on another form. This is how I would change it on with VBA tied to a form - how would I change it on another form? THanks again.

me.label.caption = "Example"

THanks

Brennan

 

[boblarson]

It would be

Forms!YourOtherFormName.YourLabelName.Caption = "Example"

 

[kenwarthen]

Forms!formName.labelName.caption = "Whatever"

 

[DCrake]

Or

Forms("YourFormName")("YourConrtolName").Caption = "Your Caption"