Re: ado error and on error statement in vba

> coding in access 2000 with ado 2.8, with code like the following, the
problem
> described in caps occurs
>
> on error goto A
> recordset![field].Value = <value> (say this will cause an error)
> recordset.update (error occurs)
> A: <fix error> (processing continues here upon error)
> on error goto B
> value = 1 / 0 (obviously this will cause an error)
> (it could be any error, even an ado
error)
> B: PROCESSING NEVER GETS HERE
> RATHER, IT'S AS IF NO ERROR HANDLER WERE IN EFFECT

Scott, I would raise this in one of Microsoft Access newsgroups
(in one of the microsoft.public.access.* newsgroups).
It is more a Access Visual Basic question.

Stephen Howe


.