By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
 448,871 Members | 1,054 Online
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,871 IT Pros & Developers. It's quick & easy.

# Record Number with a twist

 P: n/a Experts, I need your help in this tricky delima. FormA without record number at the bottom but has a customized record numbering with the following codes for "lblNavigate" label: If Me.NewRecord Then Me!lblNavigate.Caption = "New Record" Else With Me.RecordsetClone .Bookmark = Me.Bookmark Me!lblNavigate.Caption = "Record " & _ .AbsolutePosition + 1 _ & " of " & .RecordCount End With End If The records are sorted decending, showing most recent dated record on top. If I have 3 records dated 01/01/05 (record1), 0/01/05(record2) & 03/01/05(record3) respectively, when this form is open, record3 will show. When I hit acNext, it will go to record2; another acNext will bring me to record1. The above code will then show record3 as Record 1/3, record2 as Record 2/3 and record1 as record 3/3. I know this is true, but is there a way to trick it so that it is easier on "human" mind? i.e. record3 as Record 3/3, record2 as Record 2/2 and record1 as Record 1/1. I hope I explained this well enough for some insight. Thanks again. P.S.: If I sort this record Decending, the numbering is correct, but I wanted the most recent dated record on top. Is there another way to accomplish this? Sincerely, Perry Nov 13 '05 #1
Share this Question
3 Replies

 P: n/a "P.S.: If I sort this record Decending, the numbering is correct, but I wanted the most recent dated record on top. Is there another way to accomplish this? " I am sorry, I mean "If I sort these records in Ascending order, the numbering is correct..." Perry Nov 13 '05 #2

 P: n/a How about... Me!lblNavigate.Caption = "Record " & _ .RecordCount - .AbsolutePosition _ & " of " & .RecordCount ....? Nov 13 '05 #3

 P: n/a Gord, This is exactly what I wanted, thank you. Perry Nov 13 '05 #4

### This discussion thread is closed

Replies have been disabled for this discussion.