Jumping to a specific field in a form

[JustAnElf]

Greetings one and all,



Is it possible to add a shortcut key to a form so it jumps to a specific field? I've set the tab order so I can jump to all the fields in a logical manner. However there are times I only want to jump to one field and update it. Using the tab key or the mouse is a very slow process if you have several hundred records to update.

Thanks.

[ItsMe]

You can place some code in a click event. Maybe a control button or if you are tabbing to a control that you want to then skip several others, you could use that control's dblclick event, ie you arrive at a control and update the info - now you can dblclick it because you would typicaly skip the next 10 controls.

Me.specific_field.SetFocus

[JustAnElf]

Hi ItsMe,

You have a good suggestion but I'm trying to avoid the mouse click. Ideally I want to press a key combination such as CTRL+SHIFT+M and jump directly to that field. Keeping your hands on the keyboard is many times faster than stopping what you are doing and reaching for the mouse.

[ItsMe]

After I posted, I considered the feasibility. The only way I can imagine is to have some VBA fire in an event. Maybe you could use something like SendKeys or Keybord Shortcuts. I don't use them myself so I can not offer much help there.

I just see a need to have some custom code that goes to a specific field after analyzing where the current focus is.

Maybe a Case Select and .SetFocus

The trick would be to get a certain combination of keystrokes to fire the event.