I have a data entry form with a submit menu item.  When the user has filled
in the data entry form, they click submit on the menu and the record is saved
in the database and an email is sent to the user.

But, when there is an error (data validation error) on any of the fields of
the form, the User gets an error pop up stating that the data is not valid
for this field, but if they ignore the error and click submit, it will send
the email anyway, but not save the record in the table.

My users are confused because they get the email, but can’t find the record
in the database.

How can I prevent the email from being sent if any of the fields on the form
has data validation errors?

John K.