Problem with error handling

[der_roedie]

Hello,

I've created an application that connects to a database and then retrieves records from there.
This data is then send to another system that contains data for these records.
Sometimes it can happen that for a record no data exists in the second system. This raises an error in my program, so i've added small errorhandlers to coop with this problem.

BUT: the first occasion this happens, the error get handled by the errorhandler and I continue my program withe the next record. But if that records also has no data then the errorhandler does not work

This is the code for the error handler:

If Err.Number = -2147220469 Then
    Err.Clear
    rst.MoveNext
    GoTo pointnotexist
End If

The number is the same for the second error so it should work i guess. I've added Err.Clear to reset the error before continuing but that didn't work either.

Any help and tips would be appreciated.

 

[xld]

Would be better to see all of the code, but ry this

If Err.Number = -2147220469 Then
    Err.Clear
    rst.MoveNext
    Resume pointnotexist
End If

 

[der_roedie]

Thanks! This did the trick although I do not really understand the difference with the original code.

 

[xld]

Resume keeps the error handler active.