Time in and Time out

[Dgavilanes]

I have a form that tracks the following:
Date = Date()
Time in = Time()
Time Out = Time()
My problem is with Time in and time out.
Need the form to register the "time in" when the record opens in the form.
"Time Out" need the form to register the time out on Exit???
The idea is to calculate how long it takes the record to be processed.
Thank you
Dennis

 

[Dgavilanes]

Thanks for responding so quickly,
Is working just fine,.... I just noticed that when I go back to the record, "Time In" changes to the actual time.
It should stay static once completed.
Did I miss something?
Thanks
Dennis

 

[jatfill]

Assuming "timein" is null prior to you wanting to update its value (if there is another rule involved it may get a little trickier, but not impossible) you would modify the Form's Current event as follows:

If IsNull(Me.timein) Then
Me.timein = Now()
End If

This will only update the timein value if no value already exists...

 

[Dgavilanes]

Thanks to Pat, and Jatfill it works great.
and this fine site with all who get involved
Thanks
Dennis

 

[fibayne]

time in time out

another thanks to PHartman and Jatfill this worked great for me also
thanks

 

[boblarson]

Thank you fibayne!

And a big thanks to fibayne who actually did a search on the site and found the answer and didn't just post first. That is rare, but HIGHLY appreciated!