Making two label captions the same

[thebionicredneck2003]

Hi guys,



I have one label in a form say form a with a caption and I have another caption in another form say form b.

I would like the caption value of form a to be the caption value of form b so that I only need to change the caption in form a and it reflects the same caption in form b.


Thanks

[June7]

Not understanding the issue.

Set the Caption property of label to whatever you want it to say.

[thebionicredneck2003]

I apologise for not making myself clear enough. The caption value in form a's label is 5. I want to set form b's caption value to be an expression i.e. form b's caption = form a's value.


I need it this way, because I want to update the value in only one place without having to change it in two places. Hope this makes sense

[June7]

Are you talking about the form's caption (not a label control)?

Requires code to set the form Caption property. I use only VBA, don't know if macro can do. In form b Open event, select [Event Procedure], click the ellipses (...) to open VBA editor, type code.

Me.Caption = Forms!formA.Caption

[thebionicredneck2003]

Hi,

I have attached two empty forms with labels to explain things better.

Hope it clears things up.

Thank you once again for your patience and assistance so far

[June7]

Labels can't have expressions. Can use VBA to change the Caption property.

Why is this necessary? If label on frm_a always shows 10 why must label on frm_b be dependent?

[thebionicredneck2003]

Because the value of 10 will change with time

[June7]

How is the label caption changed? Why not use textboxes?

[thebionicredneck2003]

I never thought of that. Really showing my lack of knowledge here. If I use two textboxes instead, can I just use an expression similar to what you showed me earlier to get it to work?

[June7]

Expression in textbox on frm_b like:

= Forms!frm_a.textboxname

or

= Forms!frm_a.label.Caption

Set properties Locked Yes and TabStop No

Issue with using textbox as label on form is that users can click into it.

[thebionicredneck2003]

Got ya. Thanks again