Timestamp on form

D

Doug_C

Hi,

I would like to create two fields on a form, an "In" and an "Out". When a
user opens the form to enter a record the "In" automatically insert the
current time. If the user need to come back to the record to complete the
information, they will selcet "completed" from a drop down which
automatically changes the status date but I would also like this to insert a
current time in the "Out" field as well. Is this possible?

Thanks!!
 
K

Klatuu

Sure, To get your in time, put this in the Got Focus event of your form:

Me.In = time()

To get your Out time when completed is selected:
In the After Update event of your Drop Down

If Me.MyDropDown = "Completed" Then
Me.Out = Time()
End If
 
J

JohnFol

The In is simply a default value for the In field.
The Out is set on the AfterUpdate of the drop down box where they select
"completed".
 
D

Doug_C

Hi Klatuu,

This worked out great!

Thank you!

Klatuu said:
Sure, To get your in time, put this in the Got Focus event of your form:

Me.In = time()

To get your Out time when completed is selected:
In the After Update event of your Drop Down

If Me.MyDropDown = "Completed" Then
Me.Out = Time()
End If
Click to expand...
 
D

Doug_C

Now that the fields work properly, is there a way to lock them so they cannot
be edited?

Thanks!
 
Top