how to create a Previous balance field

[nhtraven]

Hi all,

I am stuck as to how to create a brought forward total into a subform.

I have tried 3 different ways and all of them do not work. Does anyone have any ideas??

I want to be able to use the total for invoicing, and need a previous balance to carry forward.

Thanks
Raven

 

[lbigk]

Hi,

I think you can use [Field].OldValue to capture the value of the field before it has been updated. So, on your subform you can refference to it.