On Error happening all the time

[rando1000]

Recently, I've rolled out an app to several users, some of whom don't have access on their computers (using runtimes libs instead). I'm trying to track down what the error is, so I put in an "On Error" statement in a likely place in the form. The code grabs the username from environment and the error code, and sends an e-mail to me with the error number. However, it executes every time, regardless of whether there's an error or not. I basically get e-mails with a value of "0" for the error.

What am I missing?

[Megalog]

Can you post one of your subroutines so we can verify that the error is being trapped correctly?

As far as a fix, you could insert a simple check in your error trap section like:

PrivateSub_Error:
    If Err.Number <> 0 Then
       <<call your email function>>
    End If
 
End Sub

[missinglinq]

As Megalog insinuated, it's difficult for us to troubleshoot your code unless we can see it!

Linq ;0)>

[rando1000]

Thanks for the replies, but I found the problem. I didn't have "Exit Sub" before my error handling routine, so even if the code was executing successfully, it was getting to the eh routine and running that code afterwards.

[missinglinq]

In other words, Access was doing exactly what you told it to do! Don't you just hate it when that happens? LOL!

Glad you figured it out, and thanks for posting the solution back to us!

Linq ;0)>