Number of record

[Jason Frazer]

How can i find the number of records in a form?

Jason Frazer

 

[losmac]

Private Sub Form_Current()
MsgBox Me.CurrentRecord
End Sub

 

[Guest]

This would give me the current record number. I was
wanting to find out how many total records are in the form.

Thanks for your time
Jason Frazer

 

[Steve Schapel]

Jason,

Me.RecordsetClone.RecordCount

....or, if it's a Continuous view form, put an unbound textbox in the
form footer with controlsource =Count(*)

- Steve Schapel, Microsoft Access MVP