Write Conflict...

[Curry]

Hi All,

I am getting a Write Conflict message after updating a field using

docmd.runcommand accmdSaveRecord

which because of Enforced Referential integrity is updating an equivalent field in another table.

I am not sure why this is happening as I am the only user..however...
The 3 choices I get in the message box includes one which allows me to "Save Record" along with "copy to Clipboard" and "Drop Changes".

Clicking the "Save Record" works fine and I can continue however I do not want this to be seen by other uses when I implement the database....

I have identified the error as = 7787 and I can short circuit the message with the following....

If DataErr = 7787 Then

XXXXXX

End If

My question then is what do I need to replace XXXXXX with in order for "Save Record" to be selected without input from a user...?????

All help appreciated.

Thanks

 

[KenHigg]

I know I'm going to get hammered on this and it is just slinging mud, but, have you tried:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70


???
ken

 

[Curry]

Thanks for that..however no go...returned another error which basically said Access was unable to update record...????

 

[KenHigg]

Can you get enough of the db in a zip file to post? Sound like you have an underlying control source locking things up...

ken

 

[Curry]

Fixed it....I had the subform Record Source set to a query.This is fine if just viewing the record but not when updating...I changed the record source to directly to the table as the extra data from the query was not needed and the Write Conflict has stopped and all updates as needed....Phew...

Thanks for your time....

Ian