[AccessD] A2K: Another Recordset Syntax Q

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





More information about the AccessD mailing list