Record Number on a Form 1

[tdfreeman]

I don't care for the Navigation Buttons at the botton of a Form. Therefore, I want to remove the buttons, but I like the count of # of records. In a report you can do a running sum to see what record you are on (there are other functions for the running sum of course, but this is how I usually use it). Can you basically do the same for a form?

Thank you for your help.

Tammy

 

[rdodge]

Form.CurrentRecord

The above code does the same thing as the record number you see with the navigation tools, as that has the current record number. Note, this is relative to where in the table/query it's positioned.

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
When the going gets tough, the tough gets going.