Either I've gone stupid .....

[Taliesyn]

Hi Gang! I'm trying to change the contents of a control's label based on the contents of another control. I've tried using the AfterUpdate on the second control but nothing happens. Am I giong stupid or have I missed the point with this and should I be going directly to the code on the form? BTW what I'm trying to do is change a label on a control from "Width Measurement" to "Diameter" based on whether or not the part number starts with a "W" - for Wire, which is round and, thus has a diameter.
I'm losing the will to live with this one and I'm absolutely certain that there's an easy solution but it currently escapes me!! HELP!!!

 

[maxmangion]

how are you trying to change the label contents ?

it should be Me.LabelName.Caption = "text goes here"

 

[BarryMK]

I've tried using the AfterUpdate on the second control but nothing happens.QUOTE]
Shouldn't that be the first control as that's whats been updated?

 

[BarryMK]

Try this. I got an error trying to assign a value to the original label so got round it by using the visible properties and adding an extra label. Access97 version

 

[BarryMK]

2003 version

 

[Taliesyn]

Obviously, I'd missed the plot on the way over here!

You may be a "Gentleman Bassist" but you found a neat answer to my problem! To be honest, I'd started to replace the label with another control; that way I could code the change but the extra label works just fine. Thank you, Sir!!

 

[BarryMK]

De nada