Register time a user needs to update a record

W

William

I need to know how long it takes for a user to create and work on a record
via a form. The record contains two fields: StartTime and EndTime. When the
new record is created, the Now() property fills in the correct StartTime
field. But I fail to enter the EndTime field when the record is left. How to
do this?
 
A

Allen Browne

Presumably you are using the form's BeforeInsert() to record when the entry
starts. Use the BeforeUpdate event of the form to record when it was
completed

This kind of thing:

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me.NewRecord Then
Me.EndTime = Now()
End If
End Sub
 
Top