Be sure that your recordset has its CursorLocation set to adUseClient.
>Hi I was only able to test this now, and I seem to be getting an error "7004: The rowset is not bookmarkable."
>
>Any ideas? I'm using Access mdb with ADO, by the way.
>
>Thanks
>
>
>
>>Try:
>>
>>Set DataGrid1.Datasource = myRecordset
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com