How can I record the date that a field is updated in access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to add a check box to a form, that when checked, stores the date that
it was checked in a field in the table that the form is linked to.
 
Not sure of your set-up. Assuming you are talking about data entry on the
bound Form, it sounds like you can use the CheckBox_AfterUpdate Event to set
the value of a TextBox (bound to the Date Field). When the Form updates the
data into the Table, the (today) date value will be updated also. The code
should be something like:

Private Sub CheckBox_AfterUpdate()
Me.txtDateChecked = Date()
End Sub
 
Back
Top