I hope the following makes sense.
I have a form called "Task Details" with a subform called "tblTaskTimes subform". The subform is nothing more than a table to log "Start" and "End" times for the task. However, there are interruptions throughout the day and so I've added in a pause command button that inserts Now() into the end time. I then also inserted a Restart that adds a new record and puts the datetime into the start field for resuming the task.
The problem I'm having is the finish or even if there is a second pause for this task, it is overriding the first occurance of the end time and not onto the last record. I'm trying to incorporate the DMax to look at the ID, but I've had absolutely no luck getting this to work.
Private Sub cmdPaused_Click()
Me.tblTaskTimes_subform!End = Now()
End Sub
Any help would be greatly appreciated.