I am creating a call sheet that has start times, duration of an shooting event (like travel time or setup time) and an end time.

The end time is calculated from the start time + the duration. I want to be able to take the end time from the previous record and insert it into the newly created record because logically the start time for the next event is the end time for the previous one.

I have attached a call sheet example to help visualise, it is the end printout so the time field is actually only a display one, mine is made up of multiple fields so you can add data with drop downs.

The basic question is - can you get data from a field in the last row of a subform and insert it into a newly created record? And how

Thanks