I have a sql server 2005 table called foo, it is a linked table
with a form using bound fields (qmsResponsibility, ncoType)
part of an afterUpdate event does this


7
If (Nz(qmsResponsibility, 0) = 20) Then
ncoType = 1
Else
ncoType = 2
End If
8
fExit:
On Error Resume Next
Exit Sub

fErr:
msgbox err.description & " " & Erl
Resume fExit

I get a msgbox with
Record in table 'foo' was deleted by another user

and erl is 7

in order to get to the afterUpdate event, the user has selected
one specific record from table foo

other than the obvious, ie. another user did in fact delete this
record? what else can cause this error ?