Current Time into a form

[Ralph Celento]

I have a form to collect sign-in time and sign-out time.
The Now() function works for the sign-in function. When I
try to capture the sign-out time it won't do it. To
expedite the sign-out process I want the individual to
select their SSN the query pulls up there record, then hit
Ok to close the form with the sign-out time captured
automatically. I have tried several events and can't seem
to get it right.

Ralph Celento

 

[Steve Schapel]

Ralph,

When you say "hit Ok", do you mean there is a Command Button for this?
If so, it would possibly be a logical place to put code to assign the
Now() value to the sign-out field, ahead of the form closing?

- Steve Schapel, Microsoft Access MVP

 

[John C.]

Why are you using SSN? Wouldn't an employee ID or Name be
sufficient? There are new restrictions as to how and what
you use the SSN for.

Your workers would probably appreciate a little privacy.