how to read RunSQL output

[Guest]

I am working on ACCESS and SQL server. I am using Access ADP to development
some forms to read/write table on SQL server. I want to use RunSQL to execute
a select query and copy the output to a variable. How can I do that?

Thanks everyone

 

[Sylvain Lafontaine]

You can't do that with RunSQL. You will have to use the
currentproject.connection.execute method to call your Select query and get
back the recordset.

http://www.devguru.com/technologies/ado/quickref/connection_execute.html