I have a main form called Invoice which contains a subform called Alterations.

The subform Alterations basically contains line items of my invoice which the dollar value is added up on a currency field of the form called Alterations_Total.

I created the code below for a "subform: on delete row" event.

The issue I'm having is that the record just deleted on the subform still gets accessed by the loop "for each record". That is causing my Alterations_Total to still take into account the last deleted item.

What am I missing here? Is there a way to refresh the subform before looping into it with the "for each record"?

---

----

Thanks,

OV