Hi,
i created a transaction file in vb with data control and access as backend. my problem is when customer enter transaction details of customer there is a chance of making wrong entry .
if this wrong data try to modified , the dependent data is not going to modify.
ex : if a cutomer no 101 had transaction on deferent dates like..

custno# name openbal date payment receipt closingbalance
101 xyz 10000 10-2-08 5000 0 5000
101 xyz 5000 17-3-08 0 1000 6000
101 xyz 6000 2-04-08 0 2000 8000
- - - - - - -
- - - - - - -

formulas :
closing balance = openbal - payment + receipt
openbal = closingbal


like this , if user found that there is wrong entry in fist or second transaction if it modified the depending fields are to me modified , but it isnot possible ,
so is there any program in vb to solve my problem