After Last Red

[-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

 

[Marc]

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

if .EOF then
msgbox 'end of file'
.movelast
end if

HTH
Marc