Function Key - F1 F2 etc "Simon Glencross" <simon.glencross[ at ]sg.consultancy.co.uk> 18.09.2006 20:39:16 Does anyone know if it is possible to use a function key to open a form in access? Thanks in advance!

Re: Function Key - F1 F2 etc "Ron Hinds" <__ron__dontspamme[ at ]wedontlikespam_garageiq.com> 18.09.2006 21:14:30 "Simon Glencross" <simon.glencross[ at ]sg.consultancy.co.uk> wrote in message news:urR7EK22GHA.1268[ at ]TK2MSFTNGP02.phx.gbl... [Quoted Text] > > Does anyone know if it is possible to use a function key to open a form in > access? > > Thanks in advance! 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).

Re: Function Key - F1 F2 etc Steve Schapel <schapel[ at ]mvps.org.ns> 18.09.2006 22:18:09 Simon, 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. -- Steve Schapel, Microsoft Access MVP Ron Hinds wrote: [Quoted Text] > 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). > >