Hi!

Should be:

select * from customer where cust_id = ?mycustid

Create the command object with parameter (as I already described), and open ADO recordset using this prepared command object instead of specifying the query for recordset.

You can also include the ID value into the string directly:

"select * from customer where cust_id = " + allt(str(thisform.mycustid))

>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