Hi,

Well I know why this happens b/c the table that the information is being pulled is the subsequently being updated however when moving to a diff customer or closing the form etc.. The user is then displayed the MsgBox of Write Conflict and supplying the user with 3 options of Disregarding Changes, Saving changes to Clipboard or Save Changes.

Baisically is their a way to restrict this write conflict msgbox and have it so that it saves the users changes every time.

cheers

monkey o_0

Never mind... got it!

DoCmd.RunCommand acCmdSaveRecord

have this code b4 the update statement if anyone is interested!

Or you can use:


Function IsDirty() As Boolean

With CodeContextObject
If .Dirty Then
DoCmd.RunCommand acCmdSaveRecord
End If
End With

End Function


Simon