Hello all
I got a write conflict, I understand why but I dont know how to go around the problem.
I made a small version of my database so you can see the problem: download link
The problem:
I got 1 table and 2 forms: table1 consist of column: ID, Task, result, result1, result2
The scenario
Form1 is a continuous form it shows all records (ID, Task and result from table1) in a textbox.
I have a GotFocusevent on the textbox which opens form2 and this form shows result1 and result2 of that specific record from table1.
In form2 I can change the value of result1 and result2 when I press a button form2 closes and writes “OK” or “NOT OK” in textbox result from form1.
Now when I immediately click in form1 on an other record I get the write error.
Becaus I changed values of 1 record in form1 and form2.
If I make a second table that contains result1 and result2 that should fix the problem but I prefer to keep all data in 1 table.
I tried "Me.dirty = false",
closing/opening or requiring is not an option because then the recent input would be filtered out (not in this test version I uploaded here).