Error Trapping

[Mike Leigh]

Just some little pointers required here...

Instead of typing all the erros available into each form is it possible to use an error function ?

Is this the best way to trap errors ?

I am asking because I have lots of On Error Goto's all over the place and it would be easier to have the common ones plonked inside a module. Any pointers anyone

Thanks in advance

 

[Robert Dunstan]

Hi

I would say yes you probably could use a module to trap standard errors. How this would be done is another matter because I don't actually use this way but hopefully someone else has.

What I tend to do is to make use of the form's OnError event and then use a Select Case statement to filter the Err.Number as I find that most of the errors are specific to that form.

HTH
Rob