If I click "Save Record"  the error msg goes away but the update fails.
On the second attempt if I click "Copy to Clipboard, the eror msg goes away but again it fails.
On the third attempt If I click "Copy to Clipborad"  IT WORKS.

Is this a bug or something?


Mike Albert

Un-comment the message box on S. And send it to us, please.

You are running into a conflict using an UPDATE statement in the After Update event of your Combo Box. Set the date directly in the form.

This is a "safety" feature in case 2 or more people are viewing the same record at the same time so that one person doesn't edit it, then the other overwrites what the first one does. In your case, your form has the record open and the vba is trying to edit the record behind it.

Here is a video related to the topic:

https://599cd.com/blog/display-article.asp?ID=1659

Sami: Here is the MsgBox uncommented.

Donald: I set the Record lock to Edited Record and I don't get the Error message but the update doesn't happen.

Kevin: you asked me to :Set the date directly in the form.  The field I want to update is not on the form.

Mike

Mike

Mike

Michael, I don't know what's going on, but let's try something else. Keep the warnings on and see if you get an error message.

Yes I do Sami.
I'm actually thinking I might move from an After Update event to an On Current event. Change the logic a bit by looking for the Completed Code (3) in the  table and if field "TPR03aDateStatChg" is blank or null, update "TPR03aDateStatChg" Then.  I see what  Kevin is saying and why it's not working now.

Mike

Sorry typing error. I meant to say I did that Sami.