Display Combobox list without using the mouse

[Mikeauz]

Hi,

Anyone have any idea if there's any shortcuts etc for displaying a combobox list without using the mouse.

The combobox always showing it's list after change and stopping when it's lost focus would be even better.

Thanks for the help
Mike

 

[BobStubbs]

Try the .DropDown method. Example:

Private Sub cmbChooseApplication_GotFocus()
    Me.cmbChooseApplication.Requery
    Me.cmbChooseApplication.Dropdown
End Sub

When the combo box receives the focus, it is requeried - to make sure that it contains an up to date list of values e.g. after an insert or update. The .Dropdown method then causes the list to drop down.



Bob Stubbs