Simple Query passing problem!

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

To use a sql string with the data control do this.
Right click on the control, go to ADODC Properties. Click RecordSource. Set CommandType to adCmdText and enter the SQL string in the Command Text box.