MoveNext

[Rick]

If I need to move down x number of records Is there some easy way to
to do it other than

movenext
movenext
a bunch of times or create a loop?

I was hoping for something like Movenext(6)

Thanks, Rick

 

[Tom van Stiphout]

On Tue, 1 Jun 2010 07:36:15 -0700 (PDT), Rick <[email protected]>
wrote:

You could write a procedure:
sub MoveNextMany(byval intHowMany as integer)
dim i as integer
for i = 1 to abs(intHowMany)
if intHowMany > 0 then
MoveNext
else
MovePrevious
end if
next i
end sub

Maybe better is to use the Bookmark technique. You can google or bing
for this. Keywords: recordsetclone, bookmark.

-Tom.
Microsoft Access MVP

 

[KARL DEWEY]

What about using - GoToRecord
Arguments - Record - Next
- Offset - your value of records?