After Last Red

  • Thread starter Thread starter -z
  • Start date Start date
Z

-z

I use A2K

On a frm, I have a cmdBtn that goes to the next rec OnClick.

What is the vba needed to account for what happens when the last rec is
reached

Thank you
 
-z said:
I use A2K

On a frm, I have a cmdBtn that goes to the next rec OnClick.

What is the vba needed to account for what happens when the last rec is
reached

Thank you
Click to expand...
if .EOF then
msgbox 'end of file'
.movelast
end if

HTH
Marc
 
Back
Top