I am building a timekeeping database and am having a problem with the records between my main form and subform.

The main form contains info such as EmployeeID, DepartmentID, PayPeriod. The subform contains an ActivityCode and the hours for that ActivityCode. Each employee ID will have several ActivityCodes/Hours for each PayPeriod.

My problem is that whenever I tab from the main form to the subform to input the ActivityCode and Hours a record is created with no ActivityCode or Hours. Then whenever I input the ActivityCodes and Hours, the records are created correctly with one record for each relationship of ActivityCode/Hours.

Bottom Line Question: Why is the record being created with no ActivityCode/Hours?

Thank you in advance for your response.