Do Cycle

  • Thread starter Thread starter Maracay
  • Start date Start date
M

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
 
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.
 
Back
Top