>Thanx but i have another question, right now this find only forward search . so for backword search i have to give conditon also, if i am in the middle of total records.
You normally use a rst.MoveFirst before doing your Find.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com