If the error is in the Open statement I would double check that the connection ghConnection is valid and open and that the syntax in the SQL string is also valid.

IOW, check that ghConnection is an object and that the State property = 1 (adStateOpen).

>The only error that I get (because the whole process stops at this point) is that the "OLE IDispatch exception code 429 from capanegocios.CapaNegocios CapaNegocios:.consultaestadocuenta e:\capanegocios.prg Error in line 15 OLE IDispatch exception code 429 from capadatos.CapaDatos CapaDatos: .estadocuenta e:\capadotos.prg Error in line 26 OLE IDis.."
> line 26 is the open() that I showed in my first message.
>
>but, this is my second open statement. there is another open statement, where I populate another RS for the first form. If I set the active connection to Null, will this make that RS unuseable?
>
> If you can not tell, I am Very new to this ADO stuff.
>