I thought that my post may have been somewhat confusing.

No. When sombody fails to fill in all the required fields it kicks them to the error screen telling them not all the required information is filled in. When they fill in the missing data and then hit the add record button it returns with the usual dbman has encountered a db error please enable debugging etc.

But when all the data fields are filled in correctly the first time and they submit the information it does not return the usual db error.

Does that make it clearer.