*Resolved* Help With Calling a SP from VB.Sincere Thanks to VBForums :)

[NewbieVB2003]

Thank you all for replying back.

My Bad ...Correct Code Snippet :

Public Function PpltRS() As Integer
    Dim pRtrn As Integer 'I got This
    pRtrn = 10 ' I got this but why is it here? it isn't being used by anything?
         RS1 p1_Id, c1_Id, Frm_Dt, To_Dt 'Opening the Rs I assume?
    PpltRS =pRtrn 
    Debug.Print "pRet ::::: " & Str(pRtrn)
End Function

Basically what I want to achieve is that the function RS1 will be invoked and we will pass parameters p1_Id, c1_Id, Frm_Dt, To_Dt and,it should give me an Output which confirms that the procedure is run sucessfully .I can be sure if the pRet value matches the Return value after running procedure.

You are right!!! I have messed up this part of the code. As it is not setting the value from the 1st Function. But how can I fix it.
Thanks