How do you put "Record n of m" on forms when Record Navigation Bar is hidden?

  • Thread starter Thread starter Nimrod
  • Start date Start date
N

Nimrod

I'm not good at programming vb so I'm not sure how to go about using
code to get the current record #, in addition to the total number of
records, to show on my form. I've hidden the Record Navigation bar to
simplify my form (make it idiot-proof), and would still like to show
the number of records total, as well as the current record number.

The following link works to show the CURRENT record, but not the total
records:
http://members.iinet.net.au/~allenbrowne/casu-10.html

Anyone have a clue how to add the total records to the form?

Thanks in advance!
Scott
 
Add a textbox to the form and type in
=Count("*")
as the control source. That should give you an idea of where to go next.
 
I'm not good at programming vb so I'm not sure how to go about using
code to get the current record #, in addition to the total number of
records, to show on my form. I've hidden the Record Navigation bar to
simplify my form (make it idiot-proof), and would still like to show
the number of records total, as well as the current record number.

The following link works to show the CURRENT record, but not the total
records:
http://members.iinet.net.au/~allenbrowne/casu-10.html

Anyone have a clue how to add the total records to the form?

Thanks in advance!
Scott
Click to expand...
CurrentRecord is the Form's current record number.
Recordset.RecordCount is the total number of records in the form's
recordset.

In the Control Source of an Unbound Control:
= CurrentRecord & " of " & Recordset.RecordCount
 
fredg said:
CurrentRecord is the Form's current record number.
Recordset.RecordCount is the total number of records in the form's
recordset.

In the Control Source of an Unbound Control:
= CurrentRecord & " of " & Recordset.RecordCount
Click to expand...

This is exactly what I was looking for. Thanks for your assistance!

Scott
 
Back
Top