Private Sub Combo1_Change() With Me.Combo2.Enabled = False Select Case Me.Combo1 Case "bob" Me.Combo2.Enabled = True Case "carol" Me.Combo2.Enabled = True Case "jeff" Me.Combo2.Enabled = False Case "freeda" Me.Combo2.Enabled = false Else: Combo2.Enabled = False End Select End Sub
Hi all , this code seems to be wrong as i cannot get the combo2 to become disabled as a result of choosing a value in combo1.
Any help would be appreciated very very very very muchly, with thanks
This bit of code is not the real code i want to successfully instigate, but a simpler example to help m understand the premise etc....
(i mean i have more than these two in my program but need to understand the correct approach, so that i may apply it to all areas in program that require tis type of validatio or whatever it needs)
Thanks agian all peeps out there