Need help with Data Grid

[Finbar]

Hello, I'm trying to set a data grid's Source property to an ADO record set;

rsOrdinary.Open "SELECT * FROM tblOrdinary WHERE coID = " & coIDIn, con,
adUseClient, adLockOptimisti c

Set frmCompanyStock .dgOrdinary.Dat aSource = rsOrdinary


I'm using an OLE DB connection to SQL server.

Am getting an error message "The rowset is not bookmarkable"

I haven't used VB for ages and never used the data grid control.

Anyone have any ideas on whats wrong?


regards,
Finbar.