End of File

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the DoCmd.FindRecord and FindNext commands to locate records on a
form. I want to exit with a message box when the last record is reached.

Does the FindRecord and FindNext commands return a value.

Thanks
 
look for the EOF like if (recclone.eof) then msgbox xxxxxx

THis is not tested and will need to be tweaked.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append a wildcard to a text search string 3
Problem with FindRecord in Access 2007 1
compile error using FindNext command 1
Somebody Please Help Me 24
Find a Record & display it on a Form!! 4
Back to first record, then forward 2
How to Delete the Current Record via VB in a Form 2
FindNext not working... ?? 4

Back
Top