carrying date into new records

[kgatchell2001]

Hi, I am a beginner working on a database to manage clients, payroll,
station assignments, etc. I am having difficulty with sick pay
variables.

I use the following variables;

SickUsed: Sick time used in a given pay period. (Cannot exceed
SickAccumulated) This term is entered by the user

SickAccumulated: SickAccumulated through previous month minus SickUsed
(A person can only use sick time accumulated through previous
payperiod)

SickEarned: If TotalHoursPaid is Less Than 80 then SickEarned Equals
TotalHoursPaid Divided by 20 or if TotalHoursPaid is Greater than or
equal to 80, then SickEarned Equals 4

SickBalance: SickAccumulated Plus SickEarned minus SickUsed (Current
Month)
The Macro: [SickAccumulated]+[SickEarned]-[SickUsed]

Here is what I am trying to do: Each month, the user will enter new
payroll information for each client. Because Sickpay is ongoing, I
would like to have the data automatically transfer when a new payroll
record is entered for a client. What I really need it to do is have
SickBalance become SickAccumulated and be transferred to that field,
when a new record for a client is selected. Can anyone out there help
me with this? If you can please be as detailed as possible in your
response as I am a beginner.

Thank you in advance,
Kgatchell2001