Executing stored procedures from adp 1

[TommyTea]

I am writing my first adp and I am trying to figure out the best way to execute a SQL Server stored procedure where the parameters are supplied from combo boxes.

 

[Databaseguy]

Dim prm As ADODB.Parameter
Dim cmd As ADODB.Command

Set cmd = New ADODB.Command
Set cmd.ActiveConnection = CurrentProject.Connection
cmd.CommandText = "sp_860Prompt"
cmd.CommandType = adCmdStoredProc

'cmd.Parameters(0).Type = adVarChar
cmd.Parameters(1).Direction = adParamInput
cmd.Parameters(2).Direction = adParamInput
cmd.Parameters(1).Value = strCust
cmd.Parameters(2).Value = dtmDate