Check box autofill date to field

[401R]

I have a form that contains a completed step checkbox and a date completed box. I want for it to automatically inser the date and time "10/31/013:16:25P.M." to the date completed when the user clicks the checkbox. I've tried doing it my way but it does do doit. Can anyone help? It seems simple but I am having alot of trouble getting it to work. Thanks in advance

 

[gusbrunston]

Hello, 401R:

Put the following code in the "On Click" event for your check box:

Private Sub NameOfCheckBox_Click()
    Me.NameOfTextBox = Now()
End Sub

Use the name of the text box, not the name of the field where you are saving the date. Of course, you will change the "NameOfTextBox" to your text box name.

Hope this is good for you.
Gus Brunston
An old PICKer
padregus@home.com