DATAGRID

[yossi]

Please help
What wrong with this code
I got error "the rowset is not bookmarkable"

Private Sub Form_Load()
Dim cn As new ADODB.Connection
cn.Open "DSN=mydsn"
Dim rs As New ADODB.Recordset
rs.ActiveConnection = cn
rs.Source = "select * from authors where [year born]>1943"
rs.Open
Set DataGrid1.DataSource = rs
rs.Close
cn.Close
Set rs = Nothing
Set cn = Nothing
End Sub

[Hollie]

on what line did you get the error?

[PatOls]

You must specify how to open the recordset....

static usually works best in grids

like:

rs.open SomeString, cn, adOpenStatic


/Patrick