The dreadfull Write Conflict error - help

[jscriptor09]

Hi folks

I have a "Condition" table in my db and 2 different forms reading from other two different tables, Form A is based on Table A, Form B is based on Form B. Both forms are loaded into an Access 2010 switchboard Navigation Form.

the Color field is common to all three tables.

Therefore, in Form A, if I change the color from Green to Red, I do so from a combo box and then trigger an event which calls a function to:


Update Table A Color Field, Update Table 2 Color Field and Update Condition Table Color Filed.

However I get this warning (please see attachment).

Please note that since Form A and Form B are inside the Navigation Switchboard windows, I suspect that the warning is because I am impacting Table B (which is linked to Form B in the Navigator Window) when I called the change event from Form A

Is there any way to suppress this warning.

Many thanks for your help
Mike

[June7]

Can't suppress. Must correct the issue causing this. Probably attempting to edit same record from two actions without saving the record between them. Would have to analyse project/code if you want to provide.