Data enviroment run time error

[lemonade]

hello!

first I want to thank everybody for answering my questions. I found this forum very helpful.

New problem I ran into:

When I am trying to execute store procedures with optional parameters i am getting run time error:

"Prepared statement '(@P1 int output, @P1 int) EXEC
@P1 = dbo.spSeect' expects parameter @P2,
which was not supplied"

Error handling doesn't help. even if I specify exact Err.Number

In the end of the following code is the place where error executes:

With oDeVe.Commands ("dbo_RptGEN_SelectTransactionList").Parameters
.Refresh

If Not oReport.Batch = 0 Then
.Item("@Batch") = oReport.Batch
End If

End With

oDeVe.Commands("dbo_RptGEN_SelectTransactionList").Execute

---------

mybe somebody had the same issue or can refer me into right direction or (even better) fix it. :-))
Thanks

[lemonade]

Believe it or not but simple "on Error Resume Next" helped

I just do not understand why it did not waork when I placed it in the error hadling procedure such as following;

on err goto to err_handler


err_handler:

Select case err.number
case -423412121
resume next
case else
----
end select

Do you know why????