Hi

I am using Access 07. I have a record which has a number of fields, what I want to do is to automatically update a second field called "last modified" which gets modified if any of the fields get modified and not on a read.

I tried attaching the following code to the Form_AfterUpdate() event
Code:
Dim db As Database
    Dim qdf As DAO.QueryDef
    
    Set db = CurrentDb
    Set qdf = db.QueryDefs("staffRecodUpdateTime")   
    
    qdf.Parameters("modTime").Value = Now()
    qdf.Parameters("staffRef").Value = CInt([Form]![Text187].Value)
    qdf.Execute dbFailOnError
    
    qdf.Close
    Set qdf = Nothing
    Set dbs = Nothing
but when i exit the form I get the "write conflict - This record has been changed by another user since you started editing it..." with the three options "save record", "drop changes", "copy to clip board"

There is no other user part from myself using the database.

Is there a way to either automatically suppress the msg or committing my change regardless?

Any help appreciated!