Dear All

I'm designing a form for Bank transactions. For this I have fields Debit. Credit, Balance, Cheque no etc.... I need to show the balance in balance field as if user enter amount in Debit field then the balance field minus that amount form Balance field and similarly if he enter amount in Credit field then balance field plus that amount in balance field. I think balance filed should show running total but how I don't know.
If anyone solve this problem I 'll be very thankful.


Regards.

Wasim

Dear Wasim;

As I understood that you have 3 fields debit, balance, credit. So, try to put the following code in Event "After Update" for Credit field:

[balance]=[balance]+[credit]

if it work, then try the same with debit but (-) operation.

Katada