Here's our Tip for.. June 26, 2000
Click Here to see a complete list of all of our previously released Tips!
Track All the Records
Apply here payday loans
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

Apply here payday loans