We have a tracking subform with date/status of shipment. Every day we have to update the status twice, adding in every update rows  depending of the status. We have created a some sendmail actions when editing wich depends on the status. We need send the email depending on the most recent status updated.

We use on success, for each record, if but the email sent always is the first status on the subform, not the last row status as we need to be. could you help us with the script?