How do you resolve a Write Conflict issue?

HELP!!!

I am having a problem in resolving a Write Conflict issue . I am trying to
create a trail in which it will show the before and after editing of a
selected record. I had created a subform with its own query to handle
transferring of the record to a table before editing. This is triggered by
the Main Form's properties using ON CURRENT.

Another subform is created with its own query to handle the transferring of
record to a table after editing. This is triggered by the AFTER UPDATE in
the Main Form's properties. After doing this, I will still get a WRITE
CONFLICT message.

What am I doing wrong? If there is a better way, I welcome it.

Thanks!!
--
Esther Fisher