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.