I am trying to show, in record 2, the details from the same field in record
1, can anyone shed some light... I have tried to use the command...

DoCmd.GoToRecord, [Record number],acLast
To bring through the previous record details to a field on the current
record...

eg:
Number = 150 in record 1
Running total = 0 in record 1

Number = 80 in record 2
Running total = 150 in record 2

Number = 425 in record 3
Running total = 230 in record 3

Many thanks in advance