simply - you can't.
It's a stored procedure and thus executed as a whole.
Perhaps you should try to change the sp to give back the values it's using and processing so you can see if they're ok.
Use the Query Analyzer for executing and give the params to the sp by hand, the messages from QA are often better than the pop-up errors from Access..
Greetings,
Jens