How do I clear a check box with data?

[trackmedic]

I would like to clear a check box on a form.

i have a check box that is activated manually when I have an "action item" on my form. when an employee clears an "action item" a date is entered in the date cleared box.

I would like the check box to automatically clear when a date is entered in the date box.

Any help?

Thanks in advance!

 

[georgedwilkinson]

There are 3 pretty good candidate events on a text box that you could use to reset the check box: Before Update, After Update, and On Change. It really depends on how you want to handle it. I'm guessing I would use the On Change event.

 

[trackmedic]

ok,

How do I do it? - Thanks

 

[georgedwilkinson]

Select the properties of the text box in question, go to the events tab, select the On Change event, click on the ellipses on the right, select Code Builder, type the word "Me." (make sure to type the period), find and click on the name of the check box in the list, type ".Value = False".

You'll need to supply additional logic to make sure a complete date has been entered. Your code may look something like:

Private Sub txttrackmedicsmagicdatefield_Change()
Me.chktrackmedicsmagiccheckbox.Value = Not IsDate(Me.txttrackmedismagicdatefield) 
End Sub