I have four tables namely 1.Customer.dbf 2.Deposit.dbf 3.Withdrawal.dbf 4.Transaction.dbf in my Bank transaction application and i have create four forms namely 1.customer.scx 2.Deposit.scx 3. Withdrawal.scx 4.tansaction.scx. In deposit table having with four fields namely 1. Accno 2.Date 3.Chequeno 4. Depamount. The withdrawal table having with four fields namely 1.Accno 2.Date 3.chequeno 4.drawalamount. The transaction table having six fields namely 1.Accno 2.Date 3. Chequeno 4.Depamount 5.drawalamount 6. balance. In transcation scx i had placed three combo box namely 1. accno 2.Datefrom 3.date to, and three command button 1.cmdTransation 2.cmdmodify 3.cmdexit. Let assume i have select any one of the accountno, for example(51633) and select date 1/4/2009 from datefrom combo and select date 30/4/2009 from dateto combo and click transaction command button, the transactions of paraticular Account no and same time balance amount will be calulated and the result will be display in browse window.

How to do this?

Awaiting yours valuable reply.