How to have a field auto populate current date time based on a different Yes/No Field

[donnie.atchison]

I have a form with Yes/No fields. What I need to happen is with the YES/No field is marked I need the field next to it to store the current Date and Time. I can make this happen but when the form is closed and opened again it updates the Date and Time in the Field. I need the Date and time not to change each time the form is opened. This is tracking a the time and action happened. This is the formula I have. Please help.



The formula is in the Form On Current area.

If Me("Tracker Returned 1") = True Then
Me("Tracker Return Time 1") = Time
End If

[donnie.atchison]

Correction the formula is the following.

If Me("Tracker Returned 1") = True Then
Me("Tracker Return Time 1") = Now()
End If

[pbaldy]

I'd use the after update event of the checkbox. That way it only fires when you change the value.

[pbaldy]

By the way, you may want to add an Else clause to wipe out the date if the value is set to False.

[donnie.atchison]

I put the above formula in the box after update but it would not work. any ideas.

[pbaldy]

Error? Wrong result? Can you attach the db here?