Message: The data has been changed

[jodjim]

I have a form with several combo boxes. The selection on the first combo box determines what data is retrieved by a pass-thru query which are then used to populate a table. The subsequent combo boxes are based on a query that grabs data from the just populated table. It's when the second combo box is accessed when the message "The data has been changed. Another user edited this record..." comes out. Is there a way to get rid of this message? I already tried set warnings to false, save record, etc. but nothing seems to fix it.

Thanks in advance for the help.

 

[Remou]

Are you accessing data via a recordset as well as through the form?

 

[jodjim]

Yes, I do.

 

[Remou]

That is probably the problem, Access sees the change to the recordset as "another user".

 

[Remou]

I should have added, save your changes and destroy the recordset before editing the form.