Stephen Lebans Record Navigation Button Problem

[Dadioles]

Hello

I have downloaded Stephen Lebans A2KRecordNavigationButtons form so that I
can use his custom navigation buttons with their autorepeat property.

When I drag his form as a sub form onto my main form the navigation buttons
work perfectly but it does not display the current record number or the
total number of records in the text box.

What have I missed?

Sorry, yet another struggling beginner.....

Best wishes to all from Les

 

[John Spencer]

As I recall the numbers don't become available until you move to the next
record. Sometimes they will be there immediately, but that seems to be with
only small recordsets.

You will see similar behavior with the built in navigation bar.

So you probably did not do anything wrong.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Dadioles]

John Spencer wrote

As I recall the numbers don't become available until you move to the next
record. Sometimes they will be there immediately, but that seems to be
with only small recordsets.

You will see similar behavior with the built in navigation bar.

So you probably did not do anything wrong.

Thanks John but unfortunately this is not the case. There is something
simple and silly that I have missed but just cannot see it.
If anyone has the time to quickly download Stephen Lebans record navigation
buttons sample database (excellent by the way) and try it I would be most
grateful.
http://www.lebans.com/recnavbuttons.htm

The zip file is only 28k and contains a very basic table and a few forms.
One form is the navigation buttons and another is a form containing the
navigation buttons as a subform to show how they work. There is another form
which does not contain the navigation buttons and if I drag the navigation
button subform into it I get exactly the same problem that I have with my
own database, the buttons work perfectly but do not display the record
number. That suggests to me that I need to do something in addition to just
dragging the navigation button subform onto the form where I want the
navigation buttons to appear.

Oh for a bigger brain...... (or maybe just a younger one).

Thanks again for listening.

Les

 

[Dadioles]

After a good nights sleep and fresh eyes I have solved the problem.
Quite simple - unless you cannot see it.

The solution was to add this entry to the master form in which the
navigation button subform was embedded:

--------------------------
Private Sub Form_Current()
' ** YOU MUST CALL THIS SUB HERE ***
' Enable/Disable Navigation Buttons as required
Call Me.SFfrmNavButtons.Form.EnableDisableButtons
End Sub
---------------------------