Putting values into text boxes.

[robert693]

I have a database with two tables. One has employee information the other days of leave an employee takes off. They are related by the employee ID number. An employee gets 20 days off each year, after 5 years they get 25. They can take full days and half days. I have a form that shows the employee information, with a subform showing the days off the employee has taken along with information about why. Every year on the anniversary of the employee's hire date the number of days the employee has left to take off rolls back to 20. I want to have two text boxes to show the current year for each employee. One will have the most recent anniversary date, the beginning of his year. The other will have the next anniversary date, the end of the employee's current year. I was wondering if I have to fill these fields manually or if there is something programmatic I can do to fill them.