payment code help

[lebalang seloka]

i have a table in ms access i have the following field names

fixedpayment,payment and balance

i want to create a vb code that will automatically add the money in fixedpayment and in payment and put the balance automatically.


help me........................................................

 

[Rich]

It's generally accepted practice not to store the balance but to use a query to obtain it

 

[lebalang seloka]

all am saying is when you add data from fixedpayment and payment fields automatically the code should show the balance within the balance field

becouse within the table i have fixedpayment,payment and balance field nmaes

 

[JamesMcS]

Will and update query do the trick? If you need it in vba just use docmd.runsql, then copy your SQL statement in.