I have tried to set a date field when I put a checkmark in a yes/no field. In the date fields control source I put the following: IIf([SetDate]=0," ",Date())
Unfortunately using Date() simply changes the date each time the day changes. I want to store a date telling my when I put the checkmark in the yes/no field and I don't want that date to change. Using Date() changes it each day. How do I set the date field to todays date when I click on the yes/no field? I don't want that date to change just because the actual date changes.
Thank You!