When I try the BeforeUpdate code it creates the illustrated error when I go to close the form. If I dont click the checkbox then I can close the form.
Private Sub completed_BeforeUpdate(Cancel As Integer)
If Date < Me.all_date Then
Cancel = True
Else
Me.comp_date = Date
End If
End Sub
Is there any alternative action that can be used instead of cancel ?
Private Sub completed_BeforeUpdate(Cancel As Integer)
If Date < Me.all_date Then
Cancel = True
Else
Me.comp_date = Date
End If
End Sub
Is there any alternative action that can be used instead of cancel ?