Ignore Error?

[Woodman650]

Does anyone know if there is a way to ignore an error? I keep getting the error 3021... and I was hoping to just prevent the error from even appearing to the user. I don't know if it's possible, but I can't diagnose the problem and it doesn't seem to be hurting the DB. I just want to ignore it. haha

 

[JoeAtWork]

Put this above the code that errors:

On Error Resume Next

After the code that causes the error, I strongly suggest re-enabling the error handler, i.e. something like:

On Error Goto MyErrorHandler

Maybe a safer strategy would be to do the following in your error handler:

MyErrorHandler:
If Err.Number = 3021 Then
    Resume Next
Else
    MsgBox "Warning, error # " & Err.Number & " occurred.  Description of the error is: " & Err.Description
End If

 

[Remou]

Error 3021 is No Current Record and I think it would be better to fix the code a little than to skip the error.

 

[Woodman650]

I haven't changed anything... and the error has mysteriously dissapeared. =/ weird