This feature is used in a Microsoft Access form. You will create a hotkey, such as Alt+D, and no matter what field on the form you are in, it will drop-down the combo you set this up on so you can do a quick search/selection.
- Open the form you have created the combo box and go into “Design View”
- Place a new command button anywhere on your form. Don’t worry about the size (just make it small). Cancel out of the wizard that pops up.
- Go to Properties (click on button in the Ribbon at the top). Click on the “Format” tab and not far down, set “Transparency” to Yes.
- Change the “Name” of the command button to “CBODropDown”.
- Make it’s “Caption” something like “&DropDown Combobox” (“&” is required; whatever letter is after the & sign is going to be the Alt+ “ “ letter. In this example it is Alt+D. NOW IS THE TIME YOU CHOOSE WHAT LETTER YOU WANT TO GO WITH ALT. IF YOU WANT IT TO BE Q, NAME IT &Q, etc.
- Now, right-click anywhere on the form and click “Build Event”. Then choose “Code Builder”. When the window opens, type:
(Remember you will want to double-check “YourComboBoxName” to make sure you know what it was named before you go in to write the below code).
Private Sub CBODropDown_Click()
YourComboBoxName.SetFocus
YourComboBoxName.DropDown
EndSub
Now the key combination Alt+ “ “ will dropdown the combobox
By Rana Kory