I have a form and there is a Yes/No Checkbox as a datatype. This field is called FileReturned. There is another field called ReturnedDate.
If the ReturnedDate field is Null, I want the checkbox to be unchecked automatically, else the checkbox should be checked. Can someone help me with the code and where to write it? Should it be on the form's current event or before update?
Here's it what i have?
If ReturnedDate is Null Then
Me.FileReturned= False
Else
Me.FileReturned=True
End If