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