>Eric,
>
> I'm using data control that binds the tables and display it to the grid. I'll probably start from the scratch if I use ADO. I've tested the code again by indexing the date/name fields and improves a little bit.
> What do you think?
Can't you just open the complete table and use the FindFirst statement to place yourself on the corresponding record?
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com