Write Conflict when user Updates Customers Information on Form.

[rsmonkey]

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

 

[rsmonkey]

Never mind... got it!

DoCmd.RunCommand acCmdSaveRecord

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

 

[Simon_MT]

Or you can use:

Function IsDirty() As Boolean
    
    With CodeContextObject
        If .Dirty Then
            DoCmd.RunCommand acCmdSaveRecord
        End If
    End With

End Function

Simon