I have a form with a text box that displays the date an employee started working for a company. Another text box displays the total number of years the employee has wroked for the company. A third displays the number of days off of leave an employee gets based on the years worked, if he worked less than 5 he gets 20 days off, over 5 years he gets 25. The last two text boxes fill in automatically when the date is place in the first. The problem is that when an employee reaches 5 years, the two other text boxes do not refresh. They still display the same information unless somebody deletes then reenters the date. I would like to know if there is some way to refresh the text boxes without having to refill the first text box?

When those two Textboxes are automatically filled in, is the information in them also stored someplace? If they are, then the solution is simple. Don't store the data.

Keagan Quilty
Kilbride, Newfoundland