Write Conflict Occurs on Me.Requery

[mekmike1]

I have a Write Conflict that occurs after I do a Me.Requery. It gives me a
dialog box that states the record has been edited since opening and would I
like to "Save" , "Undo" or "Cancel" or something like that. If I click "Save"
it works like I want it to and updates the form with the data in the
recordset that the form is tied to. The Requery is needed to update the form
to reflect setting some controls to their OldValue if the user decided to
cancel their changes. How do I Requery the form but not get that dialog box?

Thanks,

 

[Jerry Whittle]

Do the following before the Me.Requery

DoCmd.RunCommand acCmdSaveRecord