Replicate navigation controls

[sdawson]

I need to replicate the navigation buttoms in a form viz. First record, Next record, Previous record, Last record, New record, Total records etc.
All these are easy but I'm struggling with the record number of the current record displayed viz. 1 of 50, 2 of 50, 33 of 50 etc.
Any threads or code would be welcome.

 

[ghudson]

Did you try searching the forum? ;-) >>> Record X of Y

 

[sdawson]

Yes, found some complicated answers to what I belived was a simple question.
You have given me the simple answer.
Thanks.

 

[boblarson]

And just an FYI for you.

Please remember that the "Record Count" is not an identifier of a particular record. It is a numeric number that represents the position of the record in the current recordset, but factors like adding/deleting records, differing sort order, etc. will change which number is displayed for any particular record. The numbering is ONLY good for that particular session where you have the form open. If you close and reopen the form, requery the form, etc. the numbers will not necessarily be the same for any particular record.

If you want to identify a particular record, for any reason, use the record's primary key instead.

 

[sdawson]

Yes, but got a lot of complicated answers to a simple question.
You gave me the simple answer I needed.
Thanks

 

[sdawson]

Yes Bob I do understand this.
I my haste to get an quick answer I may have used incorrect terms.

 

[LPurvis]

An example of plug and play nav button subform. (Just drop onto a form as a subform and it'll drive the main form navigation).
It was only after I'd made it that I realized that Stephen Lebans has a near identical example. Oh well, good company at least.