How to use keydown with code and cancel on completion

[neelsfer]

I want to use F11 with vba code only in a specific form, and then it must cancel this F11 function after executing this function. This is what i have but F11 stays active on closing, the application.It is a bit erratic.
It must be working similarly to "setwarning = true and false"

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyF11 Then
     'KeyCode = 0   how do i add this?
 
      DoCmd.GoToControl ("RacetimingSF3")
DoCmd.GoToRecord , "", acNewRec
 
'How do i cancel F11 now?
 
 
  End If
End Sub

[neelsfer]

I have changed the code a bit.
I would rather like the F11 key to take me on my mainform (RaceSetupF) to a textbox called "txtHoldNumber1"

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyF11 Then
txtHoldNumber1.SetFocus
  End If

The current F11 keydown only works the first time i press it.

Any suggestions please.!!
ps i try to use Rfid and the software requires a keystroke = F11 in this case to go to a specific field or textbox.. From here the data is then copied into the database.

[ADezii]

Try setting the KeyPreview Property of the Form to Yes, and see what happens.

[NeoPa]

Neelsfer:
The current F11 keydown only works the first time i press it.

Isn't that what you want it to do? Although I can't see why that would be true looking at the code.

I would use something like :

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
    Static blnDone As Boolean
 
    If KeyCode = vbKeyF11 _
    And Shift = 0 _
    And Not blnDone Then
        Call txtHoldNumber1.SetFocus
        blnDone = True
    End If
End Sub