Record Number with a twist

[perryche]

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

[perryche]

"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

[Gord]

How about...

Me!lblNavigate.Caption = "Record " & _
.RecordCount - .AbsolutePosition _
& " of " & .RecordCount

....?

[perryche]

Gord,
This is exactly what I wanted, thank you.

Perry