Continuous Form - Validation Problem

[accessNator]

I have attached a sample database which has a continuous form. Its called "frmContinuous". The records that hold the continuous form data is in the tblTempDeposit.

The idea of this form is to allow the USER to enter Deposits in a batch format and submit all the records into the tblDeposit when the batch is completed and validated.

The USER inputs that are required before its submitted to the table are:
1. A Batch Control Amount and Submission Date
2. A Deposit.

If at least ONE record is successfully validated a FINISHED button appears.

If the Running Total matches the Batch Control Amount and all records are validated, then a SUBMIT button appears. When the SUBMIT is clicked, then the records are copied from the tblTempDeposit into the tblDeposit and the records are deleted from the tblTempDeposit.

But, I am having a problem with a validation process. If a record is incomplete, my FORM_BEFOREUPDATE event fires and catches the error. The problem is that it repeats the error validation twice and I dont know how to fix it.

I attached my sample database for anyone to take a look. PLUS, I would be more than happy if you have other suggestions on how to improve the coding or validation process.

Thanks in advance.

 

[accessNator]

Anyone care to take a look of my problem? I attached my DB in my original post?

Thanks in advance.