combo boxes

[Guest]

I have combo boxes in a form. I want to be able to not use the mouse at all
during data entry. Is there a way that you can tab to a combo box and then
have the information drop down using a key stroke. If you need more
clarification, when i move to the combo box using just key stroke i can not
select the entires in the combo box without using my house. Thanks for any
suggestions.

 

[Guest]

If you set the Auto expand property to true, the user only needs to start
typing to make a selection. Alternatively you could use the DropDown to
method when the combo box receives focus. You might also want to play with
the List Rows property to get a user friendly selection.

Example (from Access Help)
Private Sub SupplierID_GotFocus()
Me!SupplierID.Dropdown
End Sub