If this is a form with navigation controls, you probably want to avoid logging a time below a certain value otherwise you could get lots of records with 1 or 2 second values as user navigates between records. Note also that if your process involves form requery or refresh, the Current event will fire again but you will be on the same record. You will probably have to incorporate whatever event you use with a field on the form so as to know if it's the same record or not. A variable for the ID would have to be declared at the module level and not in the procedure itself. Same goes for the start time. Simply accepting the next execution of the Current event for the form as the end of one and the beginning of another record won't work if requery/refresh happens.
Last edited by Micron; 02-14-2018 at 07:16 PM.
Reason: added info
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.