MS-Access: hotkey to display a message box

Question

I need particular users the ability to lock a record on a form, but I don't need anything too serious such as setting different security settings.

Idea: I would like to be able to have a certain keydown combination (ex: ctrl+alt+M) to open a message box. (I'm trying to avoid making a small form because all I need returned is either yes, no, or cancel)

I have been looking around, but I'm not sure where to start with this one... Your feedback is always appreciated!

Answer 1

Have you considered AutoKeys macro?

Perhaps you wish to make it form specific?

Answer 2

I did, but I don't know how to get the functionality I want. Here is the code so far (I want to make it more complicated than just "F2")

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
 Dim strPrompt As String
 Dim strBoxTitle As String
 Dim msgAnswer As Integer

If [Manager Lock] = False Then
    strPrompt = "Lock this record?"
Else
    strPrompt = "Unlock this record?"
End If

strBoxTitle = "Manager Lock"

 Select Case KeyCode
    Case vbKeyF2
        msgAnswer = MsgBox(strPrompt, vbOKCancel, strBoxTitle)
            If msgAnswer = 1 Then
                [Manager Lock] = Not [Manager Lock]
            End If
    Case Else
 End Select
End Sub