Mark has given you the event you need to use but I'm pretty sure you know that you shouldn't be storing a calculated value. Wouldn't it be better to do the calculation on the fly? You can make a tiny subform that shows only a single field (the calculated value). Remove all the borders and other properties that make the subform look like a subform. Then you can requery this subform in the After Delete Confirm event.