Track All the Records

If you need to inhibit the navigation buttons on an Access form, you can still track the total number of records in the underlying recordset. To do so, add a text box to the form and name it txtTotal. Then add the following code to your form's Current event:
Private Sub Form_Current() Me.RecordsetClone.MoveLast Me![txtTotal] = Me.RecordsetClone.RecordCount End Sub