Strange data edit error (1 Viewer)

[CedarTree]

Hello - editing data through a form, connected to SQL server table. I get the error below ... I'm not doing anything crazy re: on_current, etc. that I can see. What's weird is that I can click OK and then the edit actually "takes". Any suggestions? Thanks.

 

[Ranman256]

some forms are designed wrong so you yourself can be the other user editing the same record.
or
you have 2 different forms/sheets open on the record.

 

[CedarTree]

Thanks - best debugging approach you might suggest? Thanks!

 

[The_Doc_Man]

Does something on / in the form do something automatic? This could be a "double-dip" in which the change is made, but then the same change is made (again).

 

[theDBguy]

Thanks - best debugging approach you might suggest? Thanks!

Try disabling all the codes in your form just to see if the error goes away.