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