You are filtering your recordset with a form variable, so redirecting isn't an option.
But your recordset code is above your update code, so that is why it doesn't have the changes. The correct solution is probably to remove the redirect and just manually move your recordset code below the update code.