>Hello everyone,
>
>I am trying to do a Do While to a specific record # :
>
>Can it be done ?
>
>
>Do While recMyRecordSetAccess.'RECNO()' <= 50
> Debug.Print recMyRecordSetAccess!Primary_last_name
> recMyRecordSetAccess.MoveNext
>Loop
If your recordset is client-sided, you can use the AbsolutePosition property.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com