Write Conflict

[mcs1000]

I have Two forms linked to the same table. The table is accessed via odbc to sql server 7.

I launch form B from form A, make changes to some of the fields then do a save on form B.

Then I try to refresh form A from form B so that when I close form B form A is updated.

I get a "Write Conflict Error" followed by error 3197.

The strange thing is if the data has been updated before or I manually enter any of the fields on form B I don't get this error.

 

[Pampers]

With what code do you save the data on form B?
How do you refresh the data on form A?

Pampers
Keeping it simple can be complicated