URGENT How do you hide error msg

[riarc]

I need to hide an ODBC error message. How do I do that?

 

[nath]

Hi Riarc,

Try this:
In your code, find out which line creates the error message, then do the following:

Sub Test()
    ...
    on error goto err_ODBC   'if finds error from now on
                         'it will jump to err_ODBC
        ... 'here is your code that creates the error
    on error goto 0          'if finds error after, will
                         'display it
    ...
    Exit Sub
err_ODBC:            
    'Here create code to deal with error
    Resume LineX          'LineX is another line in your 
                          'code where you want to jump
End Sub
[\code]


Have fun,

Nath