F
Fisher666
I am getting an error message stating Write Conflict.
What I am trying to do is show the Before and After versions of a selected
record.
Here is the process that I am using:
1. Select record (by Department)
2. As the record is loaded and displayed, the property of the form has a
query (ON CURRENT) to transfer the original version of the record to Table A
(Before Update).
3. Make your changes on the form and click SAVE Record (is this needed?)
4. Click to close the form. While the form is closing, another query is
used to transfer the edited version of the record to Table B (After Update).
At step 4, is when I receive the Write Conflict message.
Can someone tell me what I am doing wrong or have suggestions as to how I
can show two versions of a selected record?
Thank you.
What I am trying to do is show the Before and After versions of a selected
record.
Here is the process that I am using:
1. Select record (by Department)
2. As the record is loaded and displayed, the property of the form has a
query (ON CURRENT) to transfer the original version of the record to Table A
(Before Update).
3. Make your changes on the form and click SAVE Record (is this needed?)
4. Click to close the form. While the form is closing, another query is
used to transfer the edited version of the record to Table B (After Update).
At step 4, is when I receive the Write Conflict message.
Can someone tell me what I am doing wrong or have suggestions as to how I
can show two versions of a selected record?
Thank you.