I am trying to avoid creating unnecessary fields and controls in both, my table as well as in my form, therefore when i get a request to create a check box YesNo field and a date, to know the date that check box was checked, i would prefer only to create the date field in the table, while on the form display only the check boxes (as the users don't necessarily need to view the date value).
i have tried with the below code on the on click event of the check box:
If IsDate(Nz(Me.CheckControl)) Then
Me.CheckControl = ""
Me.CheckControl = DATE
however it doesn't work as next time the code runs, it will always have a date on it, something like '12/29/1899'
Would appreciate if someone has a neat solution for it,