Adding a datestamp when a checkbox is ticked

[Aimee]

I have a form with a check box which states whether the patient is 'new' or not. If I have ticked that the patient is new, I need to automatically record the date that they were added.



This is with the ultimate aim of creating a query which details this information.

Please could somebody explain (in very simple terms) how I would go about doing this?

[Missinglinq]

Replacing chkNewOrNot with the actual name of your Checkbox and DateStamp with the actual name of your Textbox that will hold the DateStamp date.

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)>

[RuralGuy]

To add to Linq's answer, the system can tell if this is a *new* record and add the timestamp automatically if you want.

[Missinglinq]

I think the Records will always be 'new,' in Access' meaning of new. The 'new' here, I believe, means new to the medical practice, i.e. they've been there before and already have one or more Records.

But I could be wrong! I have been before...or so my exes tell me!

Linq ;0)>

[Aimee]

Thanks Linq
Yes you are right about 'new' as in 'new to the practice'.

I really appeciate your help but I am a complete novice with Access. What is the 'code' and where do I type this into?