Replacing chkNewOrNot with the actual name of your Checkbox and DateStamp with the actual name of your Textbox that will hold the DateStamp date.
Code:
Private Sub chkNewOrNot_AfterUpdate()
If Me.chkNewOrNot = -1 Then
Me.DateStamp = Date
Else
Me.DateStamp = Null
End If
End Sub
The 'Else' Clause is needed in case the user ticks the Checkbox and realizes that this was a mistake.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007