ACC: How to Set a Keystroke+Click to Activate a Command Button

MORE INFORMATION

1. Open the sample database Northwind.mdb (or NWIND.MDB in version 2.0).
2. Open the Main Switchboard form in Design view.
3. Add the following event procedure to the OnMouseDown property of the Exit Microsoft Access command button:
   
   In Microsoft Access 7.0 and 97:

         Private Sub ExitMicrosoftAccess_MouseDown(Button As Integer, Shift _
               As Integer, X As Single, Y As Single)
         If Shift And acCtrlMask Then
            DoCmd.Close
         End If
         End Sub
   						

   In Microsoft Access 2.0:
   
   NOTE: In the following sample code, an underscore (_) at the end of a line is used as a line-continuation character. Remove the underscore from the end of the line when re-creating this code in Access Basic.

         Sub Exit_Microsoft_Access_MouseDown (Button As Integer, Shift As _
               Integer, X As Single, Y As Single)
         If Shift And CTRL_MASK Then
            DoCmd Close
         End If
         End Sub
   						

   Other constants available for Microsoft Access 7.0 and 97 are acShiftMask and acAltMask, representing the SHIFT and ALT keys respectively. In Microsoft Access 2.0, you can use SHIFT_MASK and ALT_MASK.
4. Save the form and open it in Form view.
5. Click the Exit Microsoft Access button. Note that Microsoft Access closes.
6. Restart Microsoft Access and open the Main Switchboard form in Form view.
7. Press CTRL and then click the Exit Microsoft Access button. Note that only the Main Switchboard form closes.