Label Bound to another Label

  • Thread starter Thread starter Dolphinv4
  • Start date Start date
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
 
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)
 
Back
Top