Hi. I want a combo box to automatically drop down when it has the focus, including when I use the .SetFocus method on it when the form opens. The problem is that the combo box only opens for a split second (I see the values listed for only a moment), but the combo box closes rather than stays open.
To try to diagnose the problem, I created a form that only contains a combo box (cmbTEST) and only the event code below. The problem occurs even with this simple situation.
I am using Access 2007 and have the following references set in the VBA editor.
* Visual Basic For Applications
* Microsoft Access 12.0 Object Library
* OLE Automation
* Microsoft 12.0 Access database engine Object Library
Thanks for any assistance.
To try to diagnose the problem, I created a form that only contains a combo box (cmbTEST) and only the event code below. The problem occurs even with this simple situation.
Code:
Private Sub Form_Open(Cancel As Integer)
Me!cmbTEST.SetFocus
End Sub
Private Sub cmbTEST_GotFocus()
Me!cmbTEST.Dropdown
End Sub
I am using Access 2007 and have the following references set in the VBA editor.
* Visual Basic For Applications
* Microsoft Access 12.0 Object Library
* OLE Automation
* Microsoft 12.0 Access database engine Object Library
Thanks for any assistance.