I have two table like tblMain another is tblTransaction in tblMain idno(PK),name,ob in is tblTransaction tid,bal,date,sale. I put the entry in tblMain like below
Idno name ob
1 abc 10000
In another table tblTransaction
Tid bal (as on) date sale
1 10000 01/01/2008 500
Now I get all field in my form frmMain and frmsubTransaction like below
frmMain
Idno
Name
Ob
frmsubTransaction in Detail section
Tid Balance(bal) date sale Closing balance(cb) cb is unbound filed like cb=bal-sal
1 10000 01/01/2008 500 9500
Now my problems is I make next entry I want balance(bal) should come automatically cb
How can I write the code in Details section


Mohamed Mohiddin
Officer

__________________
Mohamed Mohiddin
Officer