Reference to a subform prooblem

[Guest]

I have several continous forms where I find it very useful to show the record
count using a text box with Control Source = Count([CustomerID]), for
example. But I'm having trouble with syntax when the text box is on a main
form and the records are in a subform. any clues?

thank you in advance

 

[John W. Vinson]

I have several continous forms where I find it very useful to show the record
count using a text box with Control Source = Count([CustomerID]), for
example. But I'm having trouble with syntax when the text box is on a main
form and the records are in a subform. any clues?

thank you in advance

You can "relay" a count, sum, or other such aggregate. Put a textbox,
txtCount say, in the Subform Footer; you can set its Visible property
to No or simply not display the footer if you wish. Then on a mainform
textbox use a control source like

=subMySubform.txtCount

using the Name property *of the Subform Control*, which might or might
not be the same as the Name of the form within that control.

John W. Vinson [MVP]