Access 2007 RecordCount in subform based on query shows eg. "1 of 1" when it should be "1 of 3" until scroll records.

[amy3000]

I used the code found on this website to show a larger record count on a form and subform: Access Forms Masterclass #2: Custom Record Counter. The main form show the count correctly. Their are about 400 adults in the main form. The subform includes their children. So a mom with 3 kids the count should say "1 of 3" but it says "1 of 1". If I scroll through the 3 records it show the count correctly.

Here's the code I'm using. Thanks for you help.

Private Sub Form_Current()
If Me.NewRecord Then
        Me.lblRecordCounterChild.Caption = "New Record"
    Else
        Me.lblRecordCounterChild.Caption = _
         "Record " & Me.CurrentRecord & " of " & Me.Recordset.RecordCount
    End If
End Sub

 

[xenou]

IMHO record counts should not normally be relied upon -- the problem is that Access is optimized to display records before all the data is loaded. It may not bother getting a full count before it shows records.