Down arrow key in a combo box

[hje]

The users wish to use the down area key rather than the
mouse to display the drop down list in a combo box after
they have tabbed to the combo box on a form.

I would sincerely appreciate any instructions on how to
accomplish this (Access newbie).

Thanks!

 

[Toco Hara]

This might help. On GotFocus you make the combobox open
and display all records. User scrolls through records
with down/up arrow key

Function DropDown_DrowDown()
On Error GoTo DropDown_DrowDown_Err

SendKeys "%{DOWN}", False

DropDown_DrowDown_Exit:
Exit Function
DropDown_DrowDown_Err:
MsgBox Error$
Resume DropDown_DrowDown_Exit
End Function

You call function on the GotFocus.

Toco

 

[PC Datasheet]

Tell your users to tab to the combobox and then press F4. The list will drop
down and the user can move down the list with the down arrow key. Then when the
desired value is highlighted press enter.


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel

 

[Steve Coombes]

Hello -

Your users can continue to use the down arrow key to open your combo box
quite easily. Within the KeyDown event of the combo box, insert the
following code (replacing cboMyComboBox with the name of your combo box
control):

If (KeyCode = vbKeyDown) Then
Me.cboMyComboBox.Dropdown
End If

 

[hje]

Thank you Steve - that did it!