>In the init of the base class, i assign the oAdo_Conn to the following code below. (I don't do this at run time, this is just for testing).
>
>This.oAdo_Conn = createobject("adodb.connection")
>This.oAdo_conn.Cursorlocation = 3
>This.oAdo_conn.Open()

One other thing, putting that code in the Init is too late. Try the way I suggested. The ADO connection object needs to be available before you run the form. Then use the oADO_Conn property to store a character string representation of where the ADO object can be found.

I added that property instead of just putting it in the DataSource property to avoid design time errors when adding the CA to a DE using the DE Builder.

Mark McCasland
Midlothian, TX USA