Record Navigator Problem

[karatelung]

I'm trying to get the header of a subform to display "Record n of n", so I can get rid of the Access navigator on the bottom. I can get it to display which record it's on, but I can't get the RecordCount to work to display how many records are in the subform.

Here is what I have.

If Me.newrecord Then
Me!lblNavigate = "New Record"
Else
With Me.RecordsetClone
.Bookmark = Me.Bookmark
Me!lblNavigate = "Record " & Me.CurrentRecord & " of "
End With
End If


What do I need to add after the " of " part to make it display the number of records in the subform?

Thank you.

 

[charityg]

Should be .Count

 

[karatelung]

Thank you charity. Your reply let me know that I was on the right track.

I had to use:

& Me.Recordset.RecordCount

I found it by doing a search in the object browser for recordcount.