How to deal with EOF and BOF???

[jinglin]

There're two command buttons on my form called Previous Record, Next Record in order to navigate the records( I didn't use ADO or DAO recordsets). When I keep clicking on the buttons, I'll encounter an error msg saying that " You can't go to the specific record. You might be at the end of the record.", Is there a way that I can detect EOF or BOF to alert the users?

Thanks for your help in advance.

Jinglin

 

[RoyVidar]

I seldom use the .bof/.eof for that, but just trap for the 2105 in the error trapping routine:

[tt]myexit:
exit sub
myerr:
if (err.number = 2105) then
msgbox "alredy at first/last..."
else
msgbox err.description
end if
resume myexit
end if[/tt]

Roy-Vidar

 

[jinglin]

Thank you very much! It solved my problems.
Jinglin

 

[grnzbra]

Wouldn't it be better to start the OnClick event of the button with:

If Not rs.EOF
...
End If

and prevent the error rather than let the error occur and then trap it?