Checkbox to create date

[bjr001]

Hello,

I've been having difficulty trying to have a checkbox enter a date in a field when ticked and remove the date when unchecked.



Thanks for your help.

[pbaldy]

What do you have so far, and where do you have it?

[bjr001]

= if «Expr» [boxout] =true then
«Expr» [BoxOutDate]=Now()

I've checked out some examples online, however I receive the same errors:

"The expression you entered contains invalid syntax
You may have entered an operand without an operator"

Thanks.

[pbaldy]

Try this VBA code in the after update event of the checkbox:

If Me.[boxout] = True Then
  Me.[BoxOutDate]=Now()
Else
  Me.[BoxOutDate]=Null
End If

[bjr001]

Hello pbadly,

Thanks for the code and the lesson. It works as I asked.

[pbaldy]

Happy to help. I'll mark the thread solved.