Count the number of records in a subform

[SpiritedAway]

I have a main form [frmZone] and a sub form (single form) [fromZoneSub] linked master/child by [ZoneID]

If there are, say, 5 related sub form records I'm trying to get a label [LabelCount] on the sub form to say "1 of 5" and as you click through the sub form for the label to change "2 of 5", then "3 of 5" etc....basically letting the user know how many records there are and as they click to the next record know which record they're on.

Can anyone advise how I could go about accomplishing this?

I'm using Access 2007.

 

[pr2-eugin]

Why not simply use Navigation Control on the SubForm? The idea you are trying to implement already exists.. Either this or I am not getting your requirement..

 

[SpiritedAway]

I know the navigation control exists for sub form - however, it doesn't show up on my sub form. And I know I shouldn't reinvent the wheel but lets say for aesthetic purposes is it possible to replicate in a label.