How to record time for yes/no click event

[stevekos07]

Hi. I want to be able to record the time that yes/no fields are clicked to a True state. I will have several of these in the form I am to build. How do I do this? I want the time fields visible but not editable, and to record the time when a yes/no field is clicked to indicate an event has happened.
Cheers.

 

[MarkK]

Presumably you have the date/time field in the table. Put a control for it on the form, but lock it. Then handle the click event of your yes/no field, and set the date/time field, like...

Private Sub chkYesNo1_Click()
[COLOR="Green"]   'handles a click on YesNo1 and sets the value of DateTime1[/COLOR]
   Me.DateTime1 = Now()
End Sub

hth
Mark

 

[stevekos07]

I thought it would be something like that. Thanks!