@Kevin afterSubmit is called after the record has already been saved to database. If you want to change it you need to load it again. Though best practice is to use beforeSubmit event to change fields on the record