Correctly auto clear an error

[Emblem1]

I want to clear an error message automatically, but not sure about the right way to describe it in the code. I am not to worried about fixing the code, but just want to ignore the error.


Err_Save_Changes_Click:
If Err = "Update or CancelUpdate without AddNew or Edit." Then
Err.Clear
End If
MsgBox Err.Description
Resume Exit_Save_Changes_Click

End Sub

I get a type mismatch instead.

Thanks.

 

[dhookom]

Err should return a number, not the description. If you want to try to match the text of the err, try:

If err.Description  = "...." Then

Personally, I would stick with the numbers.

Duane
Hook'D on Access
MS Access MVP