hi Guys,

am using ms access 2003 for my vb6 appliction that has a table for a bank account where all the deposits to the account are entered. Now i want to derive a balance after each entry. i have done it in vb but the problem is that once you make a mistake on one entry, the final balance will be wrong.

it there a formula in vb or ms accesss that can derive the balance as entries are made and still be able to update the balance once an entry is edited?

Please Help!!!!