Hello,
Is is possible to do do this?
User has Form1 open, user presses CNTL + L (or some other letter if needed)
and it will open Form2?
If you're willing to use the Alt key instead, you can do it with
builtin features of Access. For example, you can have a Command Button
or a Label with a caption containing a letter preceded by an
ampersand: e.g. a command button with a caption of
Open &Laboratory Form
Typing Alt-L will "click" the button, which could open the form in its
Click event.
Note that Windows has defined functions for most Ctrl keystrokes;
hijacking these for other uses may really annoy some experienced
users. If I were copying and pasting text into a form control, I'd be
peeved if typing Ctrl-V executed some unexpected Form action rather
than pasting my text! Alt keys are less pre-committed.
John W. Vinson[MVP]