[Resolved] Return value of Stored Procedure

[naruponk]

Hi,

This is inside stored procedure
......
Select @Result
Return @Result
......

Then i call this stored procedure from VB

with cm
......
......
......
end with
with rs
......
......
.open cm
msgbox .recordcount
end with

I got an error that "Operation is not allow when object is closed"
I'm surely that i have open cm already, when i change to other
stored procedure it works fine. I think the problem is i dont know
how to use stored procedure which is using RETURN

I have try this stored procedure in SQL analyzer, works fine.
Can any one give me the right way to solve this problem?

Thanks for advance