Error : The data has been changed.

[Vensia]

Dear all,

I get the following error at the AfterUpdate event of the combo box.

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

Why does this error happen ?
Thanks before.

Regards,
Vensxia

 

[Michel Walsh]

Hi,


Is it possible your VBA CODE changed and saved the record that is also
the actually displayed record, through another recordset or an SQL
statement? Your VBA code *is* another user than the one in front of the
keyboard.



Hoping it may help,
Vanderghast, Access MVP

 

[Vensia]

Ok, I have changed the code like this :

set rs = me.recordsetclone
with rs
.edit
...
....
.update
end with

The error doesn't happen anymore. Is the above code true ?
Thanks.

 

[Michel Walsh]

Hi


Indeed. Another possibility would have been to save the actual record, with
a Me.Dirty=False, BEFORE making the update (with your VBA code).


Hoping it may help,
Vanderghast, Access MVP