help with a running balance on a form

[Brook]

good day all,

I have a frmchecking that I would like to create a running balance. I have
tried: Balance = Balance - Debit_Credit, but this creates balance for all
records and not for each individual record. How can I set it up to create a
new balance for each record? Should I refeerence is unique id field? and if
so how?

Thanks,

Brook

 

[Chris M via AccessMonster.com]

If Balance and Debit_Credit are seperate fields, then you can create a new
calculated control that contains the formula = Balance - Debit_Credit in
the details section.