[AccessD] A2K: Another Recordset Syntax Q

On 7 Sep 2004 at 16:26, Darren DICK wrote:

>   For x = 1 To rs.RecordCount
>   	With rs
> 	      .MoveLast
>       	 MsgBox !SiteName
>             .MoveNext
>       End With
>   Next
> 

You keep moving to the last record before you display the Sitename

Try

rs.Movefirst
While not rs.eof
     Msgbox rs!Sitename
    rs.Movenext
Wend
-- 
Stuart