Continuous Form Totals Problem

[burrina]

On my continuous form when I go to the next record I lose my totals. I have the formula on the form footer! What can I do to fix this?

How can I change this to a RunSum ? With the correct syntax?

=Nz([startingbal]-Nz([debit]))+Nz([SumCredit])

[narang]

On my continuous form when I go to the next record I lose my totals. I have the formula on the form footer! What can I do to fix this?

How can I change this to a RunSum ? With the correct syntax?

=Nz([startingbal]-Nz([debit]))+Nz([SumCredit])

Hello,

After the forms recordsource property has been defined. You may use the Recordsetclone property of the Form object to update the balance field.

ou may use the above method to arrive the net balance as of each record.

Rgds

[burrina]

[SOLVED]

Thanks anyway.