try adding
RS05.MoveFirst
I'm not sure why the code ever worked. Not sure if you are opening and
closing the recordset. A recordset is similar to a file which moves the
pointer as it move the data so when you done reading everything the
point is at the end of the file and you have to reset the pointer to the
beginning of the file before you can read the data a 2nd time.
--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=176179
Microsoft Office Help