combo box shortcuts

S

sbrewer

I have a form with a combo box. It's already set to autocomplete when I type
in the first few characters of my selection, but many of them are similar
until the end. I'd like to be able to just arrow down to get to the next
selection, but arrowing down takes me to the next field. How do I set this
shortcut? I tried using a macro, but it was more confusing than not, and I
don't know enough code to use Visual Basic.
 
S

Sprinks

Hi. AFAIK, there is no Access setting for this behavior, but you can easily
create the code for it, using the KeyDown event:

Private Sub YourCombo_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyDown Then
Me!YourCombo.Dropdown
End If
End Sub

Hope that helps.
Sprinks
 
Top