number of records

J

Jeff Klein

I have a subform that shows various records. I want to have text box on the
subform that shows the number of records that the subform is sourced to.
What is the best way to do this. I have looked at coding the form_load
event of the subform but can figure it out. Also is there a way to set the
text box's control source and get this "record number"?
 
S

Steve Schapel

Jeff,

Put an unbound textbox in the Footer section of the form, and set its
Control Source property to...
=Count(*)
 
Top