Vlad,

Thanks for the response. If I set the recordsource of the ADODC control to "select * from customer where cust_id = @mycustid". How do I set the value of the parameter?

Thanks

Jim


>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