Enable Combo Box based on Selection of 1st Combo box

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?
 
G

Guest

Yes,

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

Guest

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
 
G

Guest

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
POPULATE a textbox based on combo box selection -- QUESTION 2
Pass option box selection to combo box query criteria 6
Combo Box selection / AUTO POPULATE combo box in a different form 2
Filter combo box based on another unrelated combo box 1
Update Textbox based on Selection from Multiple Comboboxes 1
cascading combo box 20
How to filter List Box based on multiple Combo Boxes 7

Top