You have two choices.

1) Use a SQL statement that gets only the records that meet your
requirements by filtering the Database.

2) move through the recordset like the code below

With rst
.movefirst
Do While Not .EOF
Debug.Print , .Fields(0), .Fields(1)
.MoveNext
Loop


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=167796

Microsoft Office Help