Display Number records in form

[Heather]

Hi,

I created Navigation buttons that I want the user to use instead of using
the ones at the bottom of the form. I shut the ones on the bottom of the
form off. How can I display the number of records in the form next to my
Navigation I created?

I want the output to be 1 of 1000 and if the use is on 500 I want it of
course to be
500 of 1000


Thanks

 

[Al Campagna]

Heather,
On my website below, under Access Tips, see the Record Statistics sample
file.
It demonstrates how to display the information you want.
ex. (unfiltered recordset)
1 of 1000 of 1000
or
500 of 1000 of 1000

ex. (filtered recordset)
1 of 600 of 1000
or
500 of 600 of 1000
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[fredg]

Hi,

I created Navigation buttons that I want the user to use instead of using
the ones at the bottom of the form. I shut the ones on the bottom of the
form off. How can I display the number of records in the form next to my
Navigation I created?

I want the output to be 1 of 1000 and if the use is on 500 I want it of
course to be
500 of 1000

Thanks

Using an Unbound text control:
=[CurrentRecord] & " of " & [RecordsetClone].[RecordCount]