Detect when a record has been deleted?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an "On Current" prodedure that does a query using a value from the
recordset in the form that has focus. This procedure works fine exept when I
delete the current record. It seems that the form wants to run the on
current procedure against the record that I just deleted (even before the
confim dialog box fires) and then throws an errer indicating that the record
is deleted.

When I try to catch this and keep the On Current procedure from running
using the code below...
Sub OnCurrent
if IsNull(Me.Recordset.Fields("id").Value) then
exit sub
else
'run the rest of the code...
end if
end sub

I get a "record is deleted" error. How can I work around this?

Thanks!
Bernie
 
Thanks Allen, that was the simple clear thinking that my exhausted brain
couldn't seem to provide. Much appreciated.
B
 
Back
Top