check boxes - what time are they checked...?

[Iain]

is it possible to create a check box that would tell you
what time it was checked at?

if so could you give us some pointers?

thanks
Iain

 

[Neil]

Hello,

You could place a text box on the form with it's Enabled property set to
False and Locked property set to True. Then in the OnClick event for the
checkbox, place the following code:

' Check the state of the stick box
If Me.CheckBoxName = True Then
' Check box is ticked
' Enter the time in the text box
Me.TextBoxName = Now
End If

If you need to save this value then create an extra field in your table and
attach the text boxs Control Source property to this new field.

HTH,

Neil.