Record Count of a Sub form 1

[Vcscwi]

How do I get a text box on a form to display the record count of a subform?

This should be easy...

Thanks!

 

[VBslammer]

[tt]=Forms!MainForm!SubFormCtl.Form.RecordsetClone.RecordCount[/tt]

VBSlammer

"You just have to know which screws to turn." - Professor Bob

 

[traingamer]

Wow. That's a lot cleaner than the silly subform answer I gave the other day.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[Vcscwi]

And it works great! Thanks

 

[julie67]

Silly question...where do you put this code?

 

[Vcscwi]

In the control source of a text box.

 

[julie67]

I think I'm realizing that I may have to use the DCount function, as I want to count the number of attendees that are attending a function. That is...any record where Attending=Yes.