Enable Combo Box based on Selection of 1st Combo box

G

George

I have two combo boxes, the second combo box is initially not enabled. I
would like to enable it based on the selection of the first combo box. Is
this possible?
 
D

Daniel

Yes,

You can create if or case statements to validate the selection in the first
and the control the second accordingly.
 
G

George

I did try the follow, however it does work and I get no error message as to why
Any thoughts?

If Me.cboStatus.Column(1) = 4 Then
Me.cboCC.Enabled = True
End If
 
O

Ofer Cohen

On the After Update event of the first combo box you can write the code

Me.[Combo2Name].Enabled = (Me.[Combo2Name] = "SumValue")

So if the criteria will return True it will enable the second combo, or it
wont be enabled
 
Top