Your post title says this is about a form but your post suggests this is about a report?
I'm not following - you are saying you know how to do this for a report but not when it's a subreport?
Should be doable in a form, but would require a numeric and unique field sorted ascending (PK autonumber would be good) using Dsum function with a filter that DSum's where the PK_id <= Pk_id. Have not tried that but seems logical to me, but likely would have to be in a continuous form.
Last edited by Micron; 03-22-2022 at 08:16 AM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.