Method or data member not found

[Y. Hanif]

Dim rc As ADODB.Recordset
Dim Conn As ADODB.Connection

Private Sub Form_Load()
Call opendb
Set rc = New ADODB.Recordset
Set Conn = New ADODB.Connection

rc.Open ("select * from dbo.per_mdept"), Conn
DataGrid1.DataSource = rc

End Sub

in the code above I get an error "method or data member not found" how can I solve it
thanks

[wqweto]

Try Set DataGrid1.DataSource = rc

cheers,
</wqw>

[Arnoutdv]

You first call "OpenDB" then you set Conn = New ADODB.Connection
So no active connection anymore