You probably have an Error Handler set up wrongly. There probably isn't an
exit sub/function line before the error handler, so the code goes happily on
through the error handler, even if there is no error.
It should be something like
fExit:
' Close recordsets etc
Exit Function
E_Handle:
MsgBox Err.Number
Goto fExit
End Function
--
HTH
Jon
Quote:
> Hi all,
> Has anyone ever gotten an Error Message like this:
> Err.Number = 0 and there is no error message at all. I get it sometimes
> when I loop through a recordset created in VBA. The looping works as long
> as I Resume after the error occurs.
> Any help or insight would be appreciated.
> Thanks in advance,
> Chris
Strange Error Message