Faster Recordset Searching
This really can make your database searching much faster if you implement this to a big database. In normal search: Do While Not record.EOF [search criteria] record.MoveNextLoop To improve the search process, you can use this method: Record.MoveLastintCount=Record.RecordCountRecord.MoveFirst For i=1 To intCount [search criteria] Records.MoveNextNext i It can improve arround 40% faster. Try it!!