write conflict message when saving record

[EricB]

I have something strange. From within a form I have a
routine that can duplicate the current displayed record,
the problem I have now is that when the moment you change
something on the newly created record I get a Write
Conflict error message. I have 2 options Copy to
Clipboard and Drop Changes. When I click on Drop Changes,
the record is saved plus the changes made to the record
are also changed. Does anyone has a clue why I'm getting
this Write Conflict message?
Thanks for any suggestions.

 

[Jen]

Hi Eric,

I feel your pain...I get this message too. I found an
article on MSDN that has a workaround to this problem
(which I found didn't work - maybe you'll be more
successful). Unfortunately I don't have the link to the
article but I do remember the workaround. On the form
you're having the problem with, go to the form properties

 

[EricB]

nope, I'm still having the same problem.
What is weird is that when you make changes to the record
and when you click on the button named "DROP CHANGES",
that the changes are recorded. I wonder whether it has
something to do with the fact that I'm using linked SQL
tables? Nobody seems to know why this problems occurs.
Thanks Jen for your input!