The data has been changed message

[Van]

Hi All,

I have a main form and a sub-form in a one-to-many relationship. all worked well when dB was stand alone. have now migrated tables to SQL server, and form behaving strangely. I am getting the following error message:

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

When i clear this message, the record can be edited. (by the way, the error only seems to occur when i've changed data on sub-form, then gone to main form and attempted to change data).

Is this an SQL server issue?

Thank you,
Van

[HansV]

It has to do with changes to the SQL server tables not being instantaneous. Try creating an After Update event procedure for the subform:

Code: Select all

Private Sub Form_AfterUpdate()
    Me.Parent.Requery
End Sub

[Wendell]

In addition to Hans' suggestion, you will probably want to add a Timestamp field to each of your SQL Server tables. We've found that to resolve most of those kind of issues with SQL Server back-end tables.

[Van]

thanks Hans and Wendell.

I added the requery code and all works well now.

Regards,
Van