I think we need more info can you get a snapshot of the full procedure.  I think there is more to what we are shown.  

V/r
Juan

This is what runs the "Navigation" Record Count Box

Private Sub Form_Current()
    RecCountBox = Me.Recordset.AbsolutePosition + 1 & " of " & Me.Recordset.RecordCount
    
End Sub

This is what is supposed to load at form start up.

Private Sub Form_Load()
    DoCmd.GoToRecord , , acNewRec
End Sub

If you are trying to load the form on start watch richards video How to Load a Form on Startup or call the sub from form current

Private Sub Form_Current()
    RecCountBox = Me.Recordset.AbsolutePosition + 1 & " of " & Me.Recordset.RecordCount
    
End Sub

This is what is supposed to load at form start up.

Private Sub Form_Load()

    DoCmd.GoToRecord , , acNewRec
    RecCountBox = Me.Recordset.AbsolutePosition + 1 & " of " & Me.Recordset.RecordCount

End Sub

give that a try and see what happens.

V/r
Juan

I'm sorry, this code:

Private Sub Form_Load()

    DoCmd.GoToRecord , , acNewRec
    RecCountBox = Me.Recordset.AbsolutePosition + 1 & " of " & Me.Recordset.RecordCount

End Sub


did not work.
I have never had this code not work before.

Thank you for the advise.

I'm sorry, this code:
  DoCmd.GoToRecord , , acNewRec

Try this code:

Private Sub Form_Current()

    If IsNull(CustomerID) Then
        RecCountBox = Me.Recordset.RecordCount + 1 & " of " & Me.Recordset.RecordCount + 1
    Else
        RecCountBox = Me.Recordset.AbsolutePosition + 1 & " of " & Me.Recordset.RecordCount
    End If
    
End Sub

Private Sub Form_Load()

    DoCmd.GoToRecord , , acNewRec

End Sub