If the data in the form dirty : Form Events « Forms « VBA / Excel / Access / Word






If the data in the form dirty

 
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
    'If the form is dirty and the user presses page up or
    'page down, ignore the keystroke
    If Me.Dirty Then
        If KeyCode = vbKeyPageDown Or _
           KeyCode = vbKeyPageUp Then
           KeyCode = 0
        End If
    End If
End Sub

 








Related examples in the same category

1.Writing the Form_Error Event Procedure
2.Assign form Recordset in its open action
3.CancelEvent: DoCmd.CancelEvent()
4.IsLoad function
5.Form Before Update action
6.The Undo event executes before changes to a row are undone.
7.Key down event
8.Form_Filter
9.You can not only check how the filter was invoked, but you can also intercept the process when the filter is applied.
10.The Load Event Assigning a Recordset Object to the Form
11.Code for the Move Previous Button
12.Code for the Move Next Button
13.Code for the Add Button
14.Deleting a Record
15.Code for the Find Button