Combobox Issue

[Burger01]

I have this code as a part of a combobox:

Private Sub ComboBox4_change()
If ComboBox4.Value = "Up to 40 Years" Then
ComboBox3.Enabled = False
ComboBox3.Value = "N/A- Building is less than 40 years"
Label4.Enabled = False
Label18.Enabled = False
Else
ComboBox3.Enabled = True
Label4.Enabled = True
Label18.Enabled = True
End If
End Sub

WHat happens is that when "Up to 40 Years" is selected, it does what it is supposed to do by disabling combob 3 etc. But, it also loses the value selected, being "up to 40 years". Anyone know why it does this? ...and how I get around it?

Burger
This message was edited by Burger01 on 2002-09-03 16:58

 

[Burger01]

Haven't exactly solved the problem, but I have used combobox4_afterupdate() and it seems to hold the value. Only problem is that to move to the next combo, I have to tab twice. Oh well, users will have to get use to it. I have had enough of trying to figure it out for now.

Thanks to those who helped. Pity we couldn't figure the actual problem out.

BURGER