I have an ADODC control on the form and I want to pass the strSQL string that you helped me write to sequal. When I was using the Data Enviroment I used the following code:

Set MAXData = DataEnviroment.Connection.Execute(strSQL, , adCmdText)

Which worked but how do I pass the same command to the ADODC control in order to recieve the same result?

Thanks for your help

Simon