[RESOLVED] how to capture multiple key strokes at once

anyone know a way to capture multiple key strokes when a form is open? when a form is open and the user presses a combination of keys at the same time (ie cntrl+j) i want an event to fire. (much like when you hit cntrl+alt+del in windows)

microsoft access 2003

Set it up as a hot key in your menu? Then you can do what you want with it. :)

and how do i do that?

this seems to work. found this here:

If (KeyAscii And 2) And (KeyAscii = Asc("J")) Then
KeyAscii = 0
MsgBox "ok"
End If

nevermind, that just checks for a capital leter

Are you doing this in a sheet or a UserForm?

its on a form

well, finally got it:

the keydown event for the form:

Code:

---

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
HandleKeys KeyCode, Shift
End Sub

---

call this function:

Code:

---


Public Sub HandleKeys(KeyCode As Integer, Shift As Integer)

    Dim ShiftDown As Integer
    Const KEY_j = 74
    Const CTRL_MASK = 2
    ShiftDown = ((Shift And CTRL_MASK) > 0)
    Select Case KeyCode
        Case KEY_j
            If ShiftDown = -1 Then
              'do whatever here
            Else
            End If
            End Select
            KeyCode = 0
End Sub

---