please help me

[hwakern]

I want to replace my balance available fields on every employee at the end of every month with the field total allowance.please help me
i'm using Access and ado.
my table name coupon deduction and with fields
employee id, total allowance, balance available, total use

from hwa kern

[kokopeli]

I am assuming you are displaying this information in textboxes. If so, in the form unload event(?) check for the date like

If Date = 10/31/00 Then 
!BalanceAvailable = txtTotalAllowance
End If

something like that should get you started.