Search results

I'm looking to have a yes/no check box automatically checked if I add a date to another field (If Me.Date_Completed_ = whatever date it is Then Me.Completed = Yes) ...something like this is what it should look like (I think). What is the proper code to write to have what I need done? Please advise.