[RESOLVED] Access help - updating a second field automatically after inital update

[thiswayup]

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

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!

[Davadvice]

hi,

You could try the below

DoCmd.SetWarnings =False

Remember to set them to true after you have closed the form.

another option would be to add a sub and setting a boolean Value to true then call the sub when a user changes a form object like a txtname_Change Event

David

[thiswayup]

Cheers for that.

I also found another way:

If Me.Dirty = True Then Me.Dirty = False