Update Date Field with System Date when Checkbox is Clicked

[outsourceasst]

In a form I need the user to check the checkbox. OnClick the Datefield within the table should populate with the system date and a status field should be set to "NEW". I had this working but for some reason the date was being set at 12/29/1899. Any ideas as to the coding? Thanks.

Kim

 

[Rich]

Posting the code you had might be helpful

 

[rockman]

Are you using a module?

Private Sub chkBox_Click()
If chkBox.value then
Datefield = Date()
Statusfield = "New"
end if
End Sub

HTH

 

[outsourceasst]

Thank you......I knew it had to be something simple. I've spent all day working on another issue and always seem to get lost when it's a simple solution.

Thanks again.

Kim