By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,834 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

error 0 and 20

P: n/a
pol

Hi,
in an ac2000-applicatin, i allways return an error 0 in the events
afterupdate and notinlist.
When i cancel the error nr 0 by an errorhandling ( if err.number = 0 then
resume next) , i get an error nr 20 ( error with description resume without
error) .
In the afterupdate event of the combofield , there is only a "me.erfresh "
and "cbofield.requery"
what is the cause of this problem and howcan i solve this error ?

kindley regards, Pol
Aug 14 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"pol" <po*@m1236m.djwrote in message
<44***********************@news.skynet.be>:
Hi,
in an ac2000-applicatin, i allways return an error 0 in the events
afterupdate and notinlist.
When i cancel the error nr 0 by an errorhandling ( if err.number = 0
then resume next) , i get an error nr 20 ( error with description
resume without error) .
In the afterupdate event of the combofield , there is only a
"me.erfresh " and "cbofield.requery"
what is the cause of this problem and howcan i solve this error ?

kindley regards, Pol
err.number = 0 means there is no error. I think that when trying to do
a resume whitout having an actual error, you will create one saying
that, there's a resume without error.

--
Roy-Vidar
Aug 14 '06 #2

P: n/a
You forgot to put:
Exit Sub
above the error handler.

As a result, Access plows on and executes the error handler, even when there
is no error.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"pol" <po*@m1236m.djwrote in message
news:44***********************@news.skynet.be...
>
in an ac2000-applicatin, i allways return an error 0 in the events
afterupdate and notinlist.
When i cancel the error nr 0 by an errorhandling ( if err.number = 0 then
resume next) , i get an error nr 20 ( error with description resume
without error) .
In the afterupdate event of the combofield , there is only a "me.erfresh "
and "cbofield.requery"
what is the cause of this problem and howcan i solve this error ?

Aug 14 '06 #3

P: n/a
Error 0 is no error

I guess in your code you simply forget to exit the routine ?
Sub
Code here
Exit sub <<== don't forget this
ErrorHandling
End sub

Arno R

"pol" <po*@m1236m.djschreef in bericht news:44***********************@news.skynet.be...

Hi,
in an ac2000-applicatin, i allways return an error 0 in the events
afterupdate and notinlist.
When i cancel the error nr 0 by an errorhandling ( if err.number = 0 then
resume next) , i get an error nr 20 ( error with description resume without
error) .
In the afterupdate event of the combofield , there is only a "me.erfresh "
and "cbofield.requery"
what is the cause of this problem and howcan i solve this error ?

kindley regards, Pol

Aug 14 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.