auto populate time 'time out' field when user comes into a record the second time.
in [Help]
|
Prev: Access 97 SR 2
Next: auto populate time 'time out' field when user comes into a record the second time.
From: David on 28 Jun 2010 22:17 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 |