Do Cycle

[Maracay]

Hi Guys

I need to create a Cycle do while to read a table from the beginning to the
end, I am using the instruction DoCmd.GoToRecord , , acNext but when get to
the end of the table, is generating an error, basically because I don’t know
the instruction in the Do cycle to indicate the end of the file I just have
Do while true, in any case if anyone has a better idea of how to read the
table from beginning to end I would like to try it.

Thanks

 

[Maurice]

Not quit clear what you are trying to achieve here but you could use the
follwing piece for this...

If not rs.bof and not rs.eof then
do until rs.eof
'- action goes here
rs.movenext
loop
end if

This is just a piece of what you could use. Give us more info on what you
are trying to achieve.