Using part of the Navigation Buttons? 1

[Lunatic]

I'm working on a form that will be used for one year only (then a real programming team will take it over and integrate it into an online system), so I'm not looking for fancy, just functional (there will be only 1 user)

What I would like to figure out is how to recreate only part of the 'Navigation Button' option. I don't want the record navigation, just the "X record of Y records" part.

This is probably somewhere in the archives but the search is down and I'm likely looking for the wrong keywords in the FAQs.

Is there a quick and easy way to build something like this in a form?

Thanks!

***************************************
Have a problem with my spelling or grammar? Please refer all complaints to my English teacher:
Ralphy "Me fail English? That's unpossible." Wiggum

 

[PHV]

Quick and dirty, in the Current event procedure of the form:
With Me.Recordset
Me![some label].Caption = "record " & (.AbsolutePosition + 1) & " of " & .RecordCount
End With

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Lunatic]

Works wonderously!

Thanks!

***************************************
Have a problem with my spelling or grammar? Please refer all complaints to my English teacher:
Ralphy "Me fail English? That's unpossible." Wiggum

 

[PHV]

Works wonderously!
Not sure on new records ...

 

[Lunatic]

Well enough once you start navigating. It shows up 0 of 1 until you start navigating, then it shows accurately in the sub-form.

Its quick and dirty and just what I needed. And I trust the single user of this system to understand this nuance.

Thanks again!

***************************************
Have a problem with my spelling or grammar? Please refer all complaints to my English teacher:
Ralphy "Me fail English? That's unpossible." Wiggum