Display number of records on a subform

W

WildlyHarry

I have a form where you enter various criteria to locate specific records.
These records are diplayed on a subform. I want to be able to create a text
box on my form that displays the number of records contained in the subform.
Any idea on how I do this?
 
O

Ofer Cohen

In the SubFrom create a text box that count the records

=Count(*)

In the Main Form create a text box and refer to the text box in the sub form

=[SubFormControlName].Form.[TextBoxName]
 
O

Ofer Cohen

In the SubFrom footer create a text box that count the records (make this
text box not visible)

=Count(*)

In the Main Form create a text box and refer to the text box in the sub form

=[SubFormControlName].Form.[TextBoxName]
 
W

WildlyHarry

Thank you for the response. I have tried several similar methods but I
continue to get an error message. Any ideas why?

Ofer Cohen said:
In the SubFrom footer create a text box that count the records (make this
text box not visible)

=Count(*)

In the Main Form create a text box and refer to the text box in the sub form

=[SubFormControlName].Form.[TextBoxName]


--
Good Luck
BS"D


WildlyHarry said:
I have a form where you enter various criteria to locate specific records.
These records are diplayed on a subform. I want to be able to create a text
box on my form that displays the number of records contained in the subform.
Any idea on how I do this?
Click to expand...
Click to expand...
 
Top