Keyboard shortcut to navigate to a combo box

[scs]

I learned how to use the & character to underline a letter to use as a
shortcut in combination with the Alt key. Now I'd like to make away to
quickly jumb to a combo box using the keyboard. I have the tab order set
the way I want but I want to be able to get to it quickly from anywhere on
the form. Can someone give me hint? Or better yet tell me how?

Thanks
Steve

 

[fredg]

I learned how to use the & character to underline a letter to use as a
shortcut in combination with the Alt key. Now I'd like to make away to
quickly jumb to a combo box using the keyboard. I have the tab order set
the way I want but I want to be able to get to it quickly from anywhere on
the form. Can someone give me hint? Or better yet tell me how?

Thanks
Steve

Add a command button to the form.
Set it's Caption to:
C&ombo

If you don't wish to see the command button set it's Width and Height
properties to 0"

Code it's click event:
Me![ComboName].SetFocus

Whenever you press Alt + o the combo box will get the focus.

If you also would like the combo to automatically drop down at the
same time, just add to the above code:

Me![ComboName].Dropdown

 

[scs]

Excellent!!! Thanks!

I learned how to use the & character to underline a letter to use as a
shortcut in combination with the Alt key. Now I'd like to make away to
quickly jumb to a combo box using the keyboard. I have the tab order set
the way I want but I want to be able to get to it quickly from anywhere
on
the form. Can someone give me hint? Or better yet tell me how?

Thanks
Steve

Add a command button to the form.
Set it's Caption to:
C&ombo

If you don't wish to see the command button set it's Width and Height
properties to 0"

Code it's click event:
Me![ComboName].SetFocus

Whenever you press Alt + o the combo box will get the focus.

If you also would like the combo to automatically drop down at the
same time, just add to the above code:

Me![ComboName].Dropdown

 

[Joan Wild]

You can also use the & character anywhere in the label attached to the
combobox to set focus to it.