Combo list expand on enter.

[Rotor]

Hello again,

In Access 2k3, I need for the combo list to auto expand when the user tabs into the field, or click on the field. I saw that there is a DropDown command, is that correct? Just typed that in the field properties event onenter or onclick?

Thanks you.

[Rotor]

Welp, that did not work. Still looking.

[Rotor]

Welp, so far I havent found anything, or maybe I am searching for the wrong thing.

[MMcCarthy]

Welp, so far I havent found anything, or maybe I am searching for the wrong thing.

You need an event procedure on the On Enter event as follows:

Private Sub ComboName_Enter()
    Me!ComboName.Dropdown
End Sub
 

Mary

[ADezii]

Hello again,

In Access 2k3, I need for the combo list to auto expand when the user tabs into the field, or click on the field. I saw that there is a DropDown command, is that correct? Just typed that in the field properties event onenter or onclick?

Thanks you.

You can also place this code in the GotFocus() Event of the Combo Box:

SendKeys "{F4}"

[Rotor]

You need an event procedure on the On Enter event as follows:

Private Sub ComboName_Enter()
    Me!ComboName.Dropdown
End Sub
 

Mary

Thank you Mary and Dezii

Quick questions, these event codes they cannot be done thru the UI, but have to done in the VBA editor, right? I tried the dropdown event, but I may have tried it in the wrong field. Will ck.

[MMcCarthy]

Thank you Mary and Dezii

Quick questions, these event codes they cannot be done thru the UI, but have to done in the VBA editor, right? I tried the dropdown event, but I may have tried it in the wrong field. Will ck.

Yes these are both event driven codes.