Using Up and down key in an Access form

[sarah]

Hello there
I use Microsoft Office 2003. I created a form in the Access. I
arranged the Tab order but when the cursor is in the Combo Box I can't
use Up and Down key for selecting the objects in it.I should use the
mouse. Can any one help me to do so?

 

[riccifs]

Hello there
I use Microsoft Office 2003. I created a form in the Access. I
arranged the Tab order but when the cursor is in the Combo Box I can't
use Up and Down key for selecting the objects in it.I should use the
mouse. Can any one help me to do so?

Hi sarah
try to see this example code:
''Navigating a Combo Box with the keyboard'' at this link
http://www.applecore99.com/frm/frm032.asp
I hope this what you was looking for...

Bye,
stefano

 

[George Nicholson]

No mouse, no code necessary.

Alt-down will 'open' the combo. Then you can use up-down keys to select.

(BTW, this is standard behaviour in most Windows apps afaik, not Access
specific.)

HTH

 

[Dale Fye]

Another way to do this is to put some code in the GotFocus of the combo box
to automatically drop it down, so you can use your up and down keys.

Private Sub cbo_Whatever_GotFocus

me.cbo_Whatever.Dropdown

End sub

When you select the item you want and hit enter, it should close the combo
and move to the next control on your form.

HTH
Dale