Form Before Update action : Form Events « Forms « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Forms
  3. Form Events

Form Before Update action

 
Private Sub Form_BeforeUpdate(Cancel As Integer)
    If IsNull(Me.txtContactFirstName) Or _
        IsNull(Me.txtContactLastName) Or _
        IsNull(Me.txtCompanyName) Or _
        IsNull(Me.txtPhoneNumber) Then
        MsgBox "The Contact First Name, " & vbCrLf & _
            "Contact Last Name, " & vbCrLf & _
            "Company Name, " & vbCrLf & _
            "And Contact Phone Must All Be Entered", _
            vbCritical, _
            "Canceling Update"
        Me.txtContactFirstName.SetFocus
        Cancel = True
    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.The Undo event executes before changes to a row are undone.
6.Key down event
7.If the data in the form dirty
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