Personally I use pass through queries when I'm going to return records, ADO command objects to execute actions (append, update, etc). I haven't seen that method of handling parameters. My code looks like:
Code:
With cmd
.ActiveConnection = objConn
.CommandText = "procResAddNew"
.CommandType = adCmdStoredProc
.Parameters.Append .CreateParameter("@ReqDate", adDBTimeStamp, adParamInput, , dteReqDate)
.Parameters.Append .CreateParameter("@AcctID", adInteger, adParamInput, , Me.cboAcctNum)
.Parameters.Append .CreateParameter("@PuLandmark", adInteger, adParamInput, , Me.cboLandmark)
.Execute
End With