How to create Hotkey to open Query

[MartinLutfer]

Hi everyone
I am create a database in Access and I want to create Hotkey{F3} to open one of my Querries. I use this code:

Private Sub SomeControl_KeyPress(KeyAscii As Integer)
  If KeyAscii = 114 Then
    DoCmd.OpenQuery "My Querry"
    KeyAscii = 0 
  End If
End Sub

but it doesn't work :S
Could anyone help me, please

[ajetrumpet]

you can find the number for the key you want with this code:

asc(chr(KeyAscii))

press the key, use that code to get the ASC number and then put that number in your conditional and perform the check using the ASC() function instead.