Hi!
Adodc1.RecordSource = "GET_LNAME;1('" & SomeVariable & "')"
Using Dataenvironment you can add Parameter to Parameters collection of Command object and set its value in code.
>Using the ADO component (i.e. ADODC1), I have the activeX properties page set up to SQL server, that has a stored procedure "GET_LNAME".
>This stored procedure requires a parameter. I can enter a "hard coded" parameter on the RECORD SOURCE tab of the properties page (i.e. GET_LNAME;1('Cruz') when the command type is "4", (adCmdStoredProc). Is there a way to put a variable on this property page (in place of 'Cruz'), and have it passed from VB?