Retrieve value from previous record

[skwilliams]

I have a form containing the fields: Date, TransactionNo, Charge, Payment, Balance and PrvBal. The primary key field "pkAuto" isn't on the table. The subform was created as tabular. I would like to calculate each new balance as Balance=PrvBal+Charge-Payment which would be setup like a statement with a running total balance.

I have entered the DLookup Function to be called in the Payment_Exit procedure. My problem here is the first record cannot retrieve the previous balance so it needs to calculate Balance=Charge-Payment.

Attached is the db file.

Any help is greatly appreciated.

Thanks.

 

[Rich]

Why not continue with the previous post?
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=32159

 

[skwilliams]

I didn't know if it would let me attach the file to an old post.

 

[Rich]

You'll have to save it in 97ver if you want me to take a look

 

[skwilliams]

Here you go.

Thanks.

 

[Rich]

I had to delete the reports to reduce the file size

 

[skwilliams]

Thanks Rich.

It works like a charm.