form delete event

[Richard]

Thank you Peter and Allen for your earlier responses.

My goal is to update a different table depending on what record is deleted
in my form. I now get the correct value but when I try to delete it says:
"Microsoft Jet Engine canceled the operation because you tried to change
data at the same time as another user."

How can I get around this problem? I am sitting on a stand alone computer...

Richard

[Allen Browne]

If you are trying to log deletes, there are several traps along the way. For
details, see:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html

"Richard" <rw**********@chello.se> wrote in message
news:nR_4b.1505$P51.5017@amstwist00...

Thank you Peter and Allen for your earlier responses.

My goal is to update a different table depending on what record is deleted
in my form. I now get the correct value but when I try to delete it says:
"Microsoft Jet Engine canceled the operation because you tried to change
data at the same time as another user."

How can I get around this problem? I am sitting on a stand alone computer...
Richard