Datagrid Control ADO

[MJK]

Hi,
Does anyone know how to set the datagrid
to an existing ADODB Recordset?

I've been trying the following but nothing happens :-

set datagrid1.datasource = rs

Any help would be very welcome

[Clunietp]

This code works fine for me:

    Dim cn As ADODB.Connection
    Dim rs As New Recordset
   
    Set cn = New Connection
    
    cn.Open "Provider=SQLOLEDB.1;Data Source=NTSRV;Integrated Security=SSPI;Initial Catalog=Northwind"
    
    rs.Open "Select * from customers", cn, adOpenStatic, adLockReadOnly
            
    Set Me.DataGrid1.DataSource = rs