On Exit changes another field depending on value

[isoman53]

I am working on adding the function of adding a date to a field on a form On Exit from another field. If the field I am exiting has a value of "No" i want to add the current date and if it is "Yes" I want to make sure the other field is null. I can't seem to find how to do this effectively. Can someone help me here?

 

[Smart]

In the on exit (or after update event) of yourfield

If yourfield = "Yes" Then
Yourdatefield = Date
Else
Yourdatefield = Null
End If

 

[isoman53]

Thanks Smart! I knew I was trying to make it too complicated.