All,

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?

Any help appreciated,

Mark