Hey everyone,
For aesthetic purposes I have custom navigation buttons on a form. The record count should update BeforeInsert, On Current, and On Load. The code is simple, but I can't seem to get the record count to update until after an update. I'll go to my form, enter a new record (it will say 6 of 5), and only once I go to a previous record does it count the sixth record (5 of 6). Am I missing something?
Code:Private Sub Form_BeforeInsert(Cancel As Integer) Set rs = Me.RecordsetClone rs.MoveLast Me.txtRecCount = Me.CurrentRecord & " of " & rs.RecordCount End Sub