Open Form

[davey3389]

Can anyone tell me if there is a code i can enter than when i press F9 on the keyboard it opens a form

 

[John Big Booty]

You can use the KeyDown event to detect a key press, some code in that event along the lines of;

If KeyCode = 120 Then
     DoCmd.[URL="http://msdn.microsoft.com/en-us/library/office/aa220276%28v=office.11%29.aspx"]OpenForm[/URL] "YourFormName"
End If

 

[davey3389]

Thanks can you explain why F9 is key code 120

 

[John Big Booty]

Thanks can you explain why F9 is key code 120

I have no idea, it just is

 

[John Big Booty]

If you want to find out the value of a key use;

MsgBox KeyCode

In the Key Down event.

 

[davey3389]

Where do i enter the code so it works from any part of the database

 

[John Big Booty]

The Key Down event is specific to forms. So you will need at least one form open for this code to work.

 

[bob fitz]

In the Key Down event of a form, as John said in his earlier post. If the form has any controls, I think you will need to set the forms Key Preview property to Yes.

Sorry John, I got distracted and missed your last post.

 

[John Big Booty]

No problem bob, you've added a little move info that I had not thought to mention

 

[bob fitz]

No problem bob, you've added a little move info that I had not thought to mention

Yes, started with "I think" though, because I was not 100% sure I was right

 

[davey3389]

so i can enter the code in one form to open another form

 

[davey3389]

what would the change be to run a macro instead

 

[John Big Booty]

You'd need;

If KeyCode = 120 Then
     DoCmd.RunMacro "YourMacroName"
End If