How to record date/time when specific field is modified in Access 2007

Access Discussion in 'Microsoft Office' started by jmbreland, Jan 16, 2015.

  1. jmbreland


    Jan 16, 2015
    Likes Received:
    I would like for my Access 2007 database to automatically record the date/time when the data in a SPECIFIC field is modified (not when any data in the record changes).

    Here is a simplified explanation of my scenario. This database keeps track of cases in my office. A data entry form named "Cases" feeds a table named "Cases." The form includes text boxes that correspond to the fields in the table. Three of these are: "Case_Notes," "Case_Status," and "Date_Status_Change."

    I would like for the "Date_Status_Change" field to automatically reflect the current date/time whenever the data in the "Case_Status" field changes. I do not want the date/time to change when information in the "Case_Notes" field is modified.

    What code would accomplish this?

    The following code will enter the date/time for a change anywhere in the record:

    Private Sub Form_BeforeUpdate(Cancel As Integer)
    Me![Date_Status_Change].Value = Now()
    End Sub

    But I want to limit it so that it dates changes ONLY in the “Case_Status” field.
    Last edited: Jan 16, 2015
    jmbreland, Jan 16, 2015
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.