Another question please. In the following code, I would like to add a condition, "If [Status]="DELINQUENT", [Remarks] should not be left blank" but I am really at a loss on how to insert it.
Thank you.Code:Private Sub Remarks_Exit(Cancel As Integer) If [Status]="DELINQUENT", Then [Remarks] Is Not Null (there should be a message "Reason" if the control button is blank DoCmd.RefreshRecord DoCmd.GoToControl "NameOfOwner" DoCmd.GoToRecord End If End Sub