Updating Records on Form

[rjohnstone1]

I am having a little trouble updating records on a form. When a field on my form has a certain criteria, i want to change values on other records. I am using code to open a recordset (the same recordset i am using in my form) and change records. Everything is fine until i leave the form or goto a different record. I get a pop up box saying that another user has modified recordset, would you like to save changes? What can i do to avoid this box.

Thanks
Ryan

 

[Pat Hartman]

This sounds suspiciously like a poorly designed table. You have duplicated data that is causing you to have to update multiple records to keep it in sync. I strongly suggest a table re-design.

In any event, you will have better luck if you use a different query to open the recordset in code rather than re-using the one you used as the recordsource of the form.