navigation (1 Viewer)

[archiecone]

what code would you write for when you are navigating through a form and you reach the end of a recordset to make it go back to the first record?

 

[norm]

I can't guess exactly right now, but i can get you started. Look into end/beginning of file properties (EOF and BOF). By using them, you can figure out when you're at the end of a recordset. ie.

If rst.EOF then
'you're at the end.
end if

Then look into methods to navigate through recordsets like

rst.movefirst
rst.movelast
rst.movenext
rst.moveprevious

...where rst is a recordset.

good luck,
norm

 

[archiecone]

thanks norm!