Help needed to modify Lebans custom navigation buttons

[David Anderson]

Stephen Lebans' excellent custom navigation buttons solution
(http://www.lebans.com/recnavbuttons.htm) looks like it will meet a need I
have - with one exception. These custom buttons appear to be designed for the
situation where the recordset being navigated can accept new records. In my
application, no new records are permitted.

Deleting the 'Go to new record' (aka cmdNew) button from the frmNavButtons
form is an easy first step but my problem is that the 'Move to next record'
button is not disabled when I navigate to the last record. Can someone with a
better understanding of Stephen's code (Stephen perhaps!) suggest how I could
modify it to work properly in my scenario?

In case it is relevant, I am using the nav buttons on a subform.

David

 

[David Anderson]

I think I may have solved my own problem.

I added some code at the end of the EnableDisableButtons subroutine of the
frmNavButtons form that did MoveNext (twice) and then checked for EOF. If at
EOF, I then disabled the 'Move to next record' button. So far it seems to be
working...

Many thanks to Stephen for making this useful facility available for all to
share. It's much appreciated.

David