Problem Solved.
I added 'Exit Sub' just before the 'End If' of each of the defined mandatory fields e.g.
If [D67].Value = "" Then
MsgBox "There MUST be an entry in Utility Type!", vbOKOnly, "Entry Reqd"
[D67].Select
Cancel = True
Exit Sub
End If
This way, the macro stopped after each failed mandatory field.
Bookmarks