Forms

[PJ]

I have a form with the following combo and text boxes:

combo box named month
combo box named year
combo box named lending unit
text box named previous agency fee totals
text box named current agency fee totals

I'm trying to do the following:

If my data in month, year, lending unit and current ageny fee total is the
following:
Jan, 2006, 0000130 and $25,000.00 then for the next month and same lending
unit that $25,000.00 would auto fill in for previous agency fee total. How
would I code that in the previous agency fee totals text box?

I hope you can understand.

Thanks