Time/date stamp

M

Mike

I have a form to display all of my tasks. When a task is complete there is a
check box on the form that you can check indicating the task was complete.
Is there a way to have a time/date or just a date stamp that would input the
date the check was clicked?

What I would like to accomplish is when I run my completed task report I
will know when a certain task was completed.

Thank you
Mike
 
K

KARL DEWEY

You will need a DateTime field in your table. Your checkbox can perform a
SetValue on the DateTime field using an Event or macro.
 
J

John Vinson

I have a form to display all of my tasks. When a task is complete there is a
check box on the form that you can check indicating the task was complete.
Is there a way to have a time/date or just a date stamp that would input the
date the check was clicked?

What I would like to accomplish is when I run my completed task report I
will know when a certain task was completed.
Click to expand...

Sure; add a Date/Time field to your table (call it TimeCompleted say).
On the AfterUpdate event of the checkbox invoke the code builder and
put in code like

Private Sub chkCompleted_AfterUpdate()
If chkCompleted = True Then
Me!TimeCompleted = Now
End If
End Sub

John W. Vinson[MVP]
 
Top