Subform - get value from the row above

Is there a way to fetch a field value from the row above in a subform and input into the row below?

Basically - on user input, we need to fetch a field value from the above row, modify it, and input into the next row?

Any ideas much appreciate

Thanks!