Enable Combo Box based on Selection of 1st Combo box

Enable Combo Box based on Selection of 1st Combo box

Post by R2Vvcmd » Thu, 26 Apr 2007 00:16:01


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?
 
 
 

Enable Combo Box based on Selection of 1st Combo box

Post by RGFuaWV » Thu, 26 Apr 2007 00:22:04

Yes,

You can create if or case statements to validate the selection in the first
and the control the second accordingly.
--
Hope this helps,

Daniel P

 
 
 

Enable Combo Box based on Selection of 1st Combo box

Post by R2Vvcmd » Thu, 26 Apr 2007 00:32:05

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
 
 
 

Enable Combo Box based on Selection of 1st Combo box

Post by T2ZlciBDb2 » Thu, 26 Apr 2007 00:34:04

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

--
Good Luck
BS"D