Help needed to modify Lebans custom navigation buttons

D

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
 
D

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
 

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

Top