I am assuming you are displaying this information in textboxes. If so, in the form unload event(?) check for the date like
Code:
If Date = 10/31/00 Then 
!BalanceAvailable = txtTotalAllowance
End If
something like that should get you started.