access how to by pass an error

[atksamy]

i have the following code

 
On Error GoTo TableTest_Error
 
                   Set rs3 = CurrentDb.OpenRecordset(strsql3)
 
                  GoTo continue
 
TableTest_Error:
                  If Err.Number = 3061 Then
                    Call Err.Clear
                    GoTo next_table
                  Else
                    MsgBox Err.Description ' or whatever you find appropriate '
                  End If
 

here in certain cases strsql3 will not execute as the field being got might not be there in table so i get error 3061,
i am trying to by pass the error but the error keeps popping at line no 4

thanks

[Stewart Ross]

This does not seem a well-thought out way to do things - trying to open a recordset when the fields of the recordset may not match - but as you have provided no detail of what you are trying to do we can't advise on better ways to do it.

Remove your current error-handling altogether, including the On Error statement. Use

On Error Resume Next

instead.

Please note that this will result in you not being notified you of any errors at all, at least not until you override that On Error statement with a different one.

-Stewart