Combo Bow to drop down on selection (1 Viewer)

[mtagliaferri]

I have placed the following code in either the On Change and Got Focus event for a Combo Box as I would like to automatically dropdown the Combo Box list to display available values when the box is selected directly or through the tab function rather than having to click on the down arrow, but is not working.

Private Sub EventType_GotFocus()
    cboEventType.Dropdown
End Sub

 

[Gasman]

Would that be because your combo appears to be called EventType?
Also try

Me.EventType.dropdown

or

Me!EventType.dropdown

If you put

Option Explicit

at the top of your code, Access would have told you this control did not exist.

HTH

 

[JHB]

You call it different names:
EventType
cboEventType