subform Navigation Button record count; forcing immediate display

[robert.waters]

For subforms implementing the Access navigation buttons, the Record
Count (which appears to the right of the buttons
('Record:' ...buttons .... 'of 32') takes several seconds to appear
after the subform is loaded.
Is there a way to delay loading the subform, so that this record count
would be available at the same time the subform is displayed?
I utilize the navigation buttons in some cases, and feel that my users
might not realize that there is more than one record if the record
count does not appear until 3 or 4 seconds after they've initially
looked at the form.

Thanks for your help.

 

[Arvin Meyer [MVP]]

The record count on the subform is part of the subform and cannot be
separated. Typically, the record count should appear within 2 seconds,
unless there are 100s of thousands of records or your computer is very slow.
You have 2 choices, and I'm not positive the first will work. Hide the
subform in your code that opens or navigates your records for a second or 2
(or more if necessary), then make it visible again. Use the form's Timer
event to make it visible, setting the Timer interval to start the code. If
that doesn't work, you can build your own navigation buttons and add the
delay to that code. In that case, you may want to do something like:

http://www.datastrat.com/Code/Delay.txt