The snipit of code below is taken from the midst of a VBA Select Case within the "On Click" event for the combo box "Combo33". On the corresponding form, there are two combo boxes superimposed, Combo33 and cboMonths. One of the list items on the Combo33 dropdown is case 9010. When that item is selected, the intent is to switch the visibility of the two combo boxes and automatically dropdown the combo box "cboMonths". The statement "Me.cboMonths.Dropdown" you see isn't having any effect.
What might I be missing?
(BTW, the On Click event for cboMonths toggles the focus and visibility back to the nominal state for the form.)
Code:
Case 9010 ' Birthdays
Me.cboMonths.Visible = True
Me.cboMonths.SetFocus
Me.cboMonths.Dropdown
Me.Combo33 = ""
Me.Combo33.Visible = False
Exit Sub