Alex,

Thanks for the response. I had tested in code, creating the connection and record set passing .createparameter..... It did not occur to me to use the adodc1.recordsource with that string. I kept trying to enter it onto the activex properties page. Thanks again for your help.

Mark