Record counter not working

[Guest]

I have a subform that has it linked to a index (from subforms query) on the
main form. There is one main record and there are multiple records in the
sub-form. On the subform the recordslector=no and Navigation=yes. On the
navigation box it shows what record you're in but does not show the amount of
last record, as 1 0f 6. The six does not show up...until you go to the last
record then it appears and will stay there. I have tried to link it with
master/child and it didn't make any difference. A form without a subform
shows the ending count on the navigation record find. It is the subform
that blinds the value. Any thoughts on fixing it? I have written code that
puts the last number in a unbound box, but I shouldn't have to - besides it's
not as clean as it should be if it appeared in the navigation box. Thanks
in advance

 

[Guest]

I don't know what you are trying to accomplish, but the record number show in
that box is totally meaningless. Access tables do not have record numbers.
The relative record numbers will change depending on sorting and ordering.

 

[BruceM]

I think the OP means the record count on the default navigation bar in the
subform is inaccurate.

I don't know why it doesn't work, but the following line of code in the
subform's Current event sets the record count correctly when I am using
custom navigation buttons and record counter:
Me.RecordsetClone.MoveLast

As I said, I can't think why it isn't happening as it should with the
built-in navigation bar.

 

[Guest]

I don't know either, but the bottom line is they have no useful value. In
the past I have had users complain that when they used that box to try to
move to a record, they didn't get the record they expected. Since then, I
don't allow record numbers on any forms.

 

[BruceM]

To say that the record count is useless, and by implication that nobody
should ever want or need to see the record count, is way too general for my
tastes, especially since I have made good use of the capability. I have not
had problems with it, so maybe I have not yet encountered the situation in
which it does not work well. Then again, I almost invariably use custom
buttons and counter, so have not experienced the problems with the built-in
ones.

 

[Guest]

Okay, I understand what you are saying.
Could you give me an idea of one good use for the record count?

 

[BruceM]

We need to know about the number of open Corrective Action Requests, or the
number of employees in a department or in the company, or the number of
reports of a vendor messing up an order, and so forth.