Logging data and time when box is ticked

[Spencer Hazell]

I have two fields. One is for a tick box; the other i would like to show the
time that the tick box has been ticked, so it enables me to log the time when
the data type is true... is this possible?

Thanks for your support

 

[Douglas J. Steele]

In the AfterUpdate event of the checkbox, put code that confirms that the
checkbox has been checked, and then put the time if it has:

Private Sub MyCheckBox_AfterUpdate

If Me.MyCheckBox Then
Me.MyTextBox = Now()
Else
Me.MyTextBox = vbNullString
End If

End Sub