Yes, it is, using a macro. Set the Macro Name to {F2}, or whatever F-key you
want (use the braces). Set the Action to OpenForm. Enter the name of the
form in the Form Name box. Be careful which F-key you use, though. Many have
default actions which you might not want to override (e.g. F1 = Help).
Ignore Steve. He is our resident idiot and occasionally pops in with
irritating nonsense.
If you go to Access Help and seacrch for "Assign an action or set of actions
to a key", I think this is what you want. Non of the Key events in VBA
recognize the function keys. The one thing to keep in mind is create a
function key macro will disable the normal use of the function key in the
Access application mdb where you have these macros. It will not affect other
mdb files.
Just to add to Ron's otherwise excellent advice... The macro object
needs to me named AutoKeys. Where Ron referred to the Macro Name, this
goes in the Macro Name column in the macro design window... if you can't
see a Macro Name column, select it from the View menu.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
