Darren DICK
d.dick at uws.edu.au
Tue Sep 7 01:26:09 CDT 2004
Hello all Another recordset syntax question One day I'll get it < sigh > The code below does what it is supposed to do except move to the next site name in the recordset WHAT I WANT... I expect the Message box to spit up SiteName1 then I expect another message box: SiteName 2 then another Until all the SiteNames in the Recordset are iterated and displayed in sequential message boxes Problem is I get 5 message boxes (There's 5 site sin the recordset) but always the 1st Sitename never site 2 or 3 or 4 or 5 Something backwards in the syntax or not properly placed is suppose Need help - Any takers? Many thanks in advance Darren For x = 1 To rs.RecordCount With rs .MoveLast MsgBox !SiteName .MoveNext End With Next Have a great day Darren