Date field automatic fill by check mark

[QueryStumped]

Hello, I am needing help with a request. I have a form that has a checkbox along with a date field. I am needing the date field to automatically populate with the days date, if the checkbox is marked. Do I put a formula in the after update of the checkbox property?

 

[QueryStumped]

Hello, I am needing help with a request. I have a form that has a checkbox along with a date field. I am needing the date field to automatically populate with the days date, if the checkbox is marked. Do I put a formula in the after update of the checkbox property?

I was going to put =if ([checkbox]=True,Now(),Null)

 

[Pat Hartman]

How did that work for you? Either use the IIf() function or use an If Then Else

 

[oleronesoftwares]

Set default value of checkbox to 0

Under the after update event of checkbox write either of the following codes

If Me!checkbox.Value = True Then
date.text = Now()
Else
date.text =""
End If
End Sub


OR you can write this code instead after the update event of checkbox
If Me.checkbox = -1 Then
date.text = Now()
Else
date.text =""
End If
End Sub