Any idea why this error handling is being applied to all error codes? (1 Viewer)

[gojets1721]

I have the below error handling code to apply only to two types of error codes, but it is applying to all.

Any idea why?

    If Err.Number = 2001 Or 3043 Then
        MsgBox "Erorr. Restart database."
    Else
        MsgBox "Error #" & Err.Number & " - " & Err.Description, , "Export Error"
    End If
   
    Resume btnSearch_Click_Exit

 

[June7]

If Err.Number = 2001 Or Err.Number = 3043 Then

 

[Pat Hartman]

Just to be clear. This expression:

If Err.Number = 2001 Or 3043 Then

Is evaluated as
If Err.Number = 2001 Or 3043 Is True Then

Since a number always tests true, the If is always true.

 

[gojets1721]

I'm an idiot...thank you so much!

 

[Pat Hartman]

It's an easy mistake to make. People do it all the time.