I'm using the following code and it works fine for the most part, however it allows the user to move to the next record after the second attemp without entering the date resolved. How do I require the user to enter the date resolved before moving to the next record.
Private Sub Form_BeforeUpdate(Cancel As Integer)
If Not IsNull(Me.ResolveCode) And IsNull(Me.DateResolved) Then
MsgBox "Please enter the Date Resolved", vbExclamation, "FSB GovTrip"