Geek asks and answers

Error "Data has been changed" when switching from the main form to the subform

I am migrating an Access database to SQL Server using SQL Server Migration Assistant (SSMA). Access will continue to be used, but with related tables instead of local ones.

I had a problem during testing after migration with a form that contains several subforms.

Testing steps:

1) Edit the field in the main form;

2) Focus on the field in the subform;

3) Try to edit the field in the substring.

Result: an error message appears: "The data was changed. Another user edited this record and saved the changes before you tried to save your changes."

After rejecting the error message, the field in the subform can be edited. If the field in the main form is not edited, the subform can be edited without an error message.

Any ideas on what might cause this error?

I tried to save the entry of the main form in the Enter event handler for the subform control in the main form (i.e. this event occurs in the main form when you enter the control that contains the subform, and not on the sub-form itself). Irrelevant. I tried to request the main form in the same form control. Enter an event, but this will not work. The requirement of the main form moves the focus away from the subform so that it is not edited.

The MS forum suggested Me.Parent.Requery in the After_Update event for the subform. That didn't work either.

SQL Profiler , , , . , , .

, : - select, . , . , , " ". , . , . : , .

.

, Record Source 1:1 ( ). - .

, , , , , , , ( , 100 ).

+5
2

. -.

, :

Private Sub Subform1_Enter()
    Me.Subform1.Form.Requery
End Sub

, , , .

+7

, , , , Access , . . : http://support.microsoft.com/kb/302492

+3

More articles:


All Articles