date stamp

  • Thread starter Thread starter AJ Raiber
  • Start date Start date
A

AJ Raiber

Is it possible to have a yes/no checkbox cause a date
field next to it to update when it is checked? I would
imagine this should be possible, but I do not know coding
well enough to manipulate it in this way, yet. Thank you.
 
AJ Raiber said:
Is it possible to have a yes/no checkbox cause a date
field next to it to update when it is checked? I would
imagine this should be possible, but I do not know coding
well enough to manipulate it in this way, yet. Thank you.

In the AfterUpdate event of the CheckBox...

If Me![CheckBoxName] = True Then
Me![DateField] = Date() ' or Now() if you want time included.
Else
Me![DateField] = Null
End If
 
Back
Top