Remind me folks - what is the event that fires every time the record changes ( i want to display the

[Chris K]

Remind me folks - what is the event that fires every time the record changes
( i want to display the record number)

 

[Chris K]

I seem to remember it was form_current, but cant remember which property
displays current record number


Private Sub Form_Current()
With Me
lblCount.Caption = .CurrentRecord & "/" & ???????
End With
End Sub

 

[Douglas J. Steele]

CurrentRecord is the current record number, so you seem to have answered
your own question!

Are you looking for total records? The only way to be sure is to move to the
end of the form's recordset.

Me.RecordsetClone.MoveLast
Me.RecordsetClone.RecordCount