Cannot trap Err 424

D

Dave

I have a process using Access to control Project 02 through
automation. When I apply a filter that results in an empty recordset
in Project I get an Error 424 as expected; however I cannot trap the
error in order to deal with it. I have

On Error GoTo err_Project

....

err_Project:

If Err = 424 Then
[Do Something]
Else
[Do Something Else]
End If

When a recordset comes up empty, Error 424 causes Access to display an
error message instead of executing the error handler. I have tried
various workarounds to suppress this, but none of them have worked.
Does anybody have any suggestions?

Thanks
Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top