Hi.
What is wrong?
=================================================================
Private Sub cmdShowIt_Click()
Dim par1 As ADODB.Parameter
Dim par2 As ADODB.Parameter

Set cmnd = New ADODB.Command
Set cmnd.ActiveConnection = cn
cmnd.CommandType = adCmdStoredProc
cmnd.CommandText = "spShowIt"

Set par1 = cmnd.CreateParameter("Input", adTinyInt, adParamInput)
cmnd.Parameters.Append par1
par1.Value = txtNumber.Text

Set par2 = cmnd.CreateParameter("Output", adVarChar, adParamOutput)
cmnd.Parameters.Append par2

cmnd.Execute

Debug.Print cmnd(1).Value
txtName.Text = cmnd(1).Value

txtName.Enabled = True
Set cmnd = Nothing

End Sub
=====================================================================
And the Stored procedure "spShowIt" :
=====================================================================
CREATE PROCEDURE spShowIt(@number tinyint,@name varchar(20) OutPut)
AS

SET NOCOUNT ON
SELECT @name = Personel.Name
FROM Personel
WHERE Personel.NO = @number;

RETURN @name
GO

Any guide please