The error message indicates your select query does not return any records. This indicate either your search criteria is inappropriate for the records or you have reached to the end of the file. If you want to avoid such kind of error messages then you can add a small statement in your code. It is as below:
Code:
IF not (RS.EOF and RS.BOF) then
'user specified action goes here
END IF
This means if you reach the end of file, you force the database not to display any error message but instead perform the action that I specified.
Bookmarks