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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cascading combo help 3
Locking a combo box 4
Filter combo box based on another unrelated combo box 1
Pass option box selection to combo box query criteria 6
POPULATE a textbox based on combo box selection -- QUESTION 2
Populate 2nd combo box with textstringafter date selected in 1st c 1
Return a text string in 2nd combo box after date picked in 1st? 1
Radio button enables Combo Box 3

Back
Top