Enable Combo Box based on Selection of 1st Combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Yes,

You can create if or case statements to validate the selection in the first
and the control the second accordingly.
 
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
 
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
 
Back
Top