Display Number records in form

  • Thread starter Thread starter Heather
  • Start date Start date
H

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
 
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."
 
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
Click to expand...

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