[AccessD] A2K: Another Recordset Syntax Q

Thanks Stuart

A mad pom with a similar answer (and an English accent) also told me the
same thing :-))

Many thanks to you both

Have a great day

Darren



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Tuesday, 7 September 2004 4:39 PM
To: Access Developers discussion and problemsolving
Subject: Re: [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


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com