Making a combo box open (pop-down) automatically 1

[gaffonso]

I've got a combo box and I'd like it open up (pop-down and show the values as it does when you click on the down arrow) automatically. Is this possible?

Thanks!

- Gary

 

[THoey]

In Access 97, try this:

Sub cboMyComboBox_GotFocus()
Me!cboMyComboBox.DropDown
End Sub Terry M. Hoey

 

[Guest_imported]

If you need the combobox to dropdown when you open the form you may use this procedure. Remember to setfocus before using dropdown keyword.

Private Sub Form_Open(Cancel As Integer)
On Error GoTo Err_Form_Open

Me!cboMyComboBox.SetFocus
Me!cboMyComboBox.Dropdown

Exit_Form_Open:
Exit Sub

Err_Form_Open:
MsgBox Err.Description
Resume Exit_Form_Open

End Sub