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

C

carterjoey

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.
 
V

Van T. Dinh

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
 
Top