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