How can display current balance at the time of data entries in cash book.

I create cash book like this in Access form, and table link with the SQL Server 2000.

table name CASH
Invdate Desc DB CR BAL
---------------------------------------------
1/10/2004 Bal c/f 0 0 10000
2/10/2004 Sales 3000 13000
3/10/2004 Exp 2000 11000
.......
and so on...

I want that at the time of data entries in cash book current balance should also
display in the data entries form, how can do ?
only DB and CR data have to do data entries, not enter
balance, Balance should be display automaticaly, how ?

there are some procedure or event procedure on lost focus
in the Access Properties ?

Please help.

Mateen

As a caution advice do not store a total or running balance in the table. There are numerous reasons not to do this from the standpoint of data integrity. Do this in a report or form.

Try using the below as an example

To run a calculation each time you enter a new record total, you need
a "Running Balance" field to hold the data, and on the Debit/credit

AfterUpdate event you can make this calculation:

Private Sub TotalDebit_AfterUpdate()
Me.Balance = Me.Amount - Me.TotalDebit
Me.Running_Balance = Me.PrevBal + Me.Balance
End Sub


I hope you get the idea



Jaime E. Maccou
Applications Analyst

Thanks for your response.

what is amount and prevbal ?
how display (see) the balance in the report or form ?

my form have three fields,ie
db, cr and bal
I have to create one more field running_balance field in the form.
so what will be coding will use in afterupdate event in running_balance field ?

this coding will use running_balance field ?
ie

Me.Bal = Me.CR - Me.DB
Me.Running_Balance = Me.Running_balance + Me.Bal

please send the coding.
thanks for your cooperation.

regards.

Mateen

Not to take you away from my original suggestion; look tat this article first.
http://support.microsoft.com/kb/210338/EN-US/

Jaime E. Maccou
Applications Analyst

thanks.