Need help on auto pop time through a form

[David]

Hi, I am trying to have a 'time out' field auto populate when the user
comes into the record the second time. The first time when the user
creates the record, the 'time in' field is auto populated by the code:
Format(Time(),"Medium Time") in the table's default value. The user
opens the record the second time through a form. I have tried to use
the above code in the empty 'time out' textbox's default value, but
nothing happens. I have also tried 'if' statements in the 'on open
Event Procedure', but have not been successful yet. Can anyone help
me? Thanks much. David

 

[Tom van Stiphout]

On Tue, 29 Jun 2010 18:43:20 -0700 (PDT), David

The formatting is just gravy. I would start with (in the Form_Open
event):
If IsNull(Me.myTimeOutField.Value) Then Me.myTimeOutField.Value = Now
(of course you replace myObjectNames with yours)

-Tom.
Microsoft Access MVP

 

[dtabse]

I would just give up. It's impossible unless you can do it, then it wouldn't be impossible.