Error to re-edit the record

[Guest]

I have a form that as you move through it, it runs some update queries based
on data in certain fields. After these queries have run (they run in a
macro, that also contains "Run Command - Save Record" after each query) if we
try to edit a field in the form we get a pop-up error that says:

The data has been changed. Another user edited the record and saved the
changes before you attempted to save your changes. Re-edit the record.

The "OK" button is the only choice, so when I click "OK" it lets me edit the
record and move on. No previous changes are lost. It allows the edit to
continue, it is just very annoying because it pops up so often!

Any way to prevent this message?? I found a similar problem that was solved
by using: If me.Dirty then me.Dirty = False before running the code. I
tried this but it didn't make a difference. Maybe I didn't put it in the
right place.....can anybody help??

Thanks!!
Susan

 

[Guest]

New Info:
This form is pulling data from a SQL table, and if I make a copy of the
table as a local Access table, I do NOT get this error! Of course, I have to
leave it a SQL, but maybe I should use different code for saving a record in
SQL as opposed to Access??