Question How to link yes/no box with a Date field?

[ltmon]

Hi everyone!

I'm really new with this software, I don't know if someone can help me:

I have a form in which I have four yes/no boxes to indicate in which part of the process is the product.

What I want is that when the last box is checked, automatically the field that I have for Closing Date set the date.

Is this possible? and if it is, how and where can I do it?

Thank you!!!

 

[Steve R.]

Yes it can be done. The quick answer, use the controls "onClick" event to trigger the VBA to automatically enter the date on the closing date control.

 

[McSwifty]

Extending on that you can add a little bit to hide (or not) depending on where the tick marks are.

If Me.SomeField = true then
    Me.SomeDateField = Date()
    Me.SomeDateField.Visible = True
Else
    Me.SomeDateField = Null
    Me.SomeDateField.Visible = False
End if

I use this as it shows the user something has happened and helps to make sure they see feedback on the form.

Unfortunately with my project; I try to make it as fool-proof as possible and someone keeps making better fools.