Label Bound to another Label

D

Dolphinv4

Hi,

is it possible to bound a label to another label with a lookup, ie,

Label1 = AXY
Label2 = 123 whereby there is a table showing that AXY belongs to 123?

Thanks,
Dolphin
 
D

Douglas J. Steele

You can't do it dynamically, but you can in code:

Me.Label2.Caption = "123 whereby there is a table showing that " &
Me.Label1.Caption & " belongs to 123?"

You might be better off using text boxes than labels. Then, you can make it
dynamic. Make the ControlSource property of the second text box equal to

="123 whereby there is a table showing that " & Me!Text1 & " belongs to
123?"

(including the equal sign)
 
Top