number of records

  • Thread starter Thread starter Jeff Klein
  • Start date Start date
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"?
 
Jeff,

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