Proactive 2105 error for bof/eof?

[twgonder]

I've got buttons on a form for previous and next record.
It gets the expected 2105 error at when going beyond the first or last records as expected.
At the moment I have it trapped in error handling.
I would like to be proactive. (the reason is I often turn off error handling for debugging code, and this error then gets in the way)
I've tried me.recordset.bof & .eof but they always come back false just before the DoCmd.GoToRecord Record:=acPrevious is executed.
Is there a better/correct way to test?
Thanks

[moke123]

use .absoluteposition

here's a custom class for navbars. See the test for .AbsolutePosition in the class module.
The 2nd to last argument -Optional CycleRecs As Boolean = True - determines whether the records cycle either to the first or last records at the end, or if a message box is fired.

[twgonder]

use .absoluteposition

here's a custom class for navbars....

Thanks, that tip did the trick. And, you'll keep me busy analyzing how you managed to turn my ten lines of code into 150 or so!

[moke123]

Thanks, that tip did the trick. And, you'll keep me busy analyzing how you managed to turn my ten lines of code into 150 or so!

write it once and I never need to write it again. Just drop it in an app and 3 lines of code and it works. No need to code any of the command buttons.

Dim clsNB As clsNavBar


Private Sub Form_Load()
Set clsNB = New clsNavBar
clsNB.InitCls Me, Me.btonext, Me.btoprev, Me.btoFirst, Me.btoLast, Me.btoNew, True
End Sub

[twgonder]

write it once and I never need to write it again. Just drop it in an app and 3 lines of code and it works. No need to code any of the command buttons.
...
[/CODE]

Yep, I do the same with a form template. All my ten lines are in one module. It's just not a class module:
https://www.accessforums.net/showthr...304#post502304

However, I will want to examine all the other tricks you did in yours. Good job.

[moke123]

However, I will want to examine all the other tricks you did in yours. Good job.

Given some of your non-traditional methods I'm surprised you don't use any custom classes.