OK, so I have a table with StartTime and EndTime fields. I will be entering activity based time sheets for employees and since one activity starts when the previous one ended, I want Access to automatically generate the StartTime. I have a single timesheet per day with related child records for each activity.

So, on my form at the top I have the Date of the timesheet then I have a subform with a datasheet view of the activity records which are related via timesheetID. All that is working fine I'm just trying to give background info.

So when I enter an activity record I want to be able to enter the first record with both the StartTime and EndTime but I want the next records to auto-generate their StartTimes by pulling the EndTime from the previous record.

Does that make sense?