Auto update of date field

[ase33592]

Please help as I was unable to find the solution. I have a field that is a yes/no check box, when this field has a check mark in it, as in true I would like to automatically update a date field in the same record, with the date the box was checked, how can this be done. Thank you

[TG_W]

Set your After Update event with the VBA code below.

If Me.Yes/NoField Name Here = True Then
Me.YourDateFieldNameHere = Date()
Else: End If

If you want to clear the date fill on the check box being false instead of "Else: End If", put

Else
Me.YourDateFieldNameHere = Null
End If