Adding Running Total To Form

[Guest]

I have a form for a deposit database which I am creating; each record represents a check and the user inputs the "Total Deposit Amount" and then the amounts from that total number that goes into different G/L accounts. I am trying have a field which shows the amount which hasn't been applied yet,"Unapplied Balance". It would be a formula of (Total Deposit - sum(of the distribution fields). I have tried just using the formula but it doesn't calculate just for that record but rather all of the records. Since a record is not posted to the table until it is finished I can't use the table as the source.

Any ideas

Where are the field values stored when they are entered into a form but have not yet been posted to the table?

Thanks
Kevin

 

[Elwin]

Prior to the form's recordset being updated, the value of
a bound text box control resides in its 'Text' property.

Me!myTextBoxControlName.Text

-----Original Message-----
I have a form for a deposit database which I am creating;

each record represents a check and the user inputs
the "Total Deposit Amount" and then the amounts from that
total number that goes into different G/L accounts. I am
trying have a field which shows the amount which hasn't
been applied yet,"Unapplied Balance". It would be a
formula of (Total Deposit - sum(of the distribution
fields). I have tried just using the formula but it
doesn't calculate just for that record but rather all of
the records. Since a record is not posted to the table
until it is finished I can't use the table as the source.

Any ideas?

Where are the field values stored when they are entered

into a form but have not yet been posted to the table??