I have two forms, both with after update events that update data on a subform bound by a query. The form itself is bound by a table where the data is filtered by a select statement. The current record on the form is being updated with the after update events are run. One form works great and I never get this error but the other one I do get the error fairly often. I read online and one solution was to add a timestamp column? Is there a timestamp data type or is that only in SQL databases? Another form said that I should make the form requery. Does that mean a simple me.requery statement in my code? If so, where?

Any advice is appreciated.

Thank you

This issue is probably due to the fact that the record is already flag as in "edit mode" and another process/form is trying to update the same record.

The key is to make sure that you have the record saved.

The record can be save with


The suggestion of use of Me.Requery will work since it does is force a save the record but it also does a lot more that may not be necessary.