Hi!

Try following:

cmdCommand = CreateObject("ADODB.Command")
cmdCommand.ActiveConnection = objConnection && connection object if you already prepared it
cmdCommand.CommandType = adCmdTable
cmdCommand.CommandText = "MyViewName"

parParam = cmdCommand.CreateParameter("ParamName", adVarChar, adParamInput, 30, "Test")
cmdCommand.Parameters.Append(parParam)

cmdCommand.Execute

HTH.

>Hello,
>
> I have a form with the adodc control on it. I am linking the adodc to a SQL server database. I want to set the recordsource to a parameterized view on the database. How do I pass the parameter to the view through the adodc control?
>
>Thanks,
>
>Jim