Displaying current/total records in sub-form

[GregoryWest]

I have a sub-form that will have a random number of records depending on the calling form. It is important that the user know that they have looked at all the records. What I want to do, is pretty much copy what is down in the navigation part of a the sub-form "Record ## of 88" in the header in big letters.


As silly as it should I am having trouble figuring out how I can get the current and total records in the sub-form query. If this available in Access 2010 anywhere?

 

[theDBguy]

Maybe something like?

="Record " & [SubformName].[Form].[AbsolutePosition] & " of " & [SubformName].[Form].[Recordset].[RecordCount]

 

[theDBguy]

Another possible approach is to use the Current Event of the subform to update the header. For example:

Me.Parent.TextboxName="Record " & Me.CurrentRecord & " of " & Me.Recordset.Recordcount