Preserve Form POST Data Displaying Errors
Originally Said By: Ray Borduin
You would have to create the recordset after the update if you wanted it to have the updated values. Just move the code that updates the database above the recordset code or more the recordset below the update and I think it will give you the result you are looking for. 
That didn't work. I only update the database if there are not any errors from my validations. It seems like what you're saying is update the database with incorrect data, them display it. I'm confused! I've attached my updated code with your suggestion of putting the update code BEFORE the recordset.
