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(*)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looping thru Subform Records 11
Subform Null Values 1
Basing a subform on a selection from either of two subforms 1
trying to minimize Write Conflicts in a multi-user database 64
Subform Navigation 3
How to position records in a scrolling subform 5
wrong subform total 2
Open form to proper record 6

Back
Top