Set field to Now()

[shepkrm]

Hello,

I've been trying to find how to do this online to no avail...

I have a form with a checkbox on it. When a user clicks the checkbox, I would like the date field on the form (cert date) to be set to Now(). I would also like to make the form read only.

I tried:
Private Sub Cert_Click()

set [cert date] = Now()
Form.RecordsetType = snapshot

End Sub

...but it threw an error.

Any ideas?

Thank you!!!
Becky

 

[lameid]

Me![Cert date] = Now()
docmd.RunCommand acCmdSaveRecord
Me.RecordsetType = 2

 

[shepkrm]

Works like a charm!

Thanks!