number of records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff Klein - 11 Feb 2006 05:06 GMT

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"?

Reply to this Message

Steve Schapel - 11 Feb 2006 07:56 GMT

Jeff,

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

Signature

Steve Schapel, Microsoft Access MVP

> 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"?

Reply to this Message