Hello Richard, I was wondering if you could shed some light on how to track employee vacation time. I created a database with the following tables: EmployeeT, HolidayT, and AbsenceT. I created a query to capture on the Vacation time (VacationID = 1) for use as a subform in my Employee form. I am able to enter the period of days taken and all calcutations work however, when I move away from the record and and come back to it the data is no longer visible. However, if I go to the AbsentT the data has been recorded except the AbsenceTypeID. If I manually type the ID in the table and return to the form I can see the vacation data along with all calculation. What am I doing wrong?