Lookup Wizard list visibility

[KHill]

As one is typing in a field with a lookup wizard - dropdown list - is there anyway to see the list without clicking on the down arrow? Perhaps there is a choice somewhere in the program where dropdown menus for the lookup wizard can be made visible??


thanks
K

[June7]

This is example of what I do:

Private Sub cbxItem_Enter()
Me.cbxItem.Dropdown
End Sub

[KHill]

I assume this code is placed somewhere in the Field properties. Where? thanks
K

[June7]

No, it is a VBA event procedure. The event is Enter. Select the combobox, on the Event tab of the properties dialog, select [Event Procedure] in the box next to OnEnter. Double click the ellipses (...), this will put you into the VBA procedure. Type code.