Display number of records on a subform

G

Guest

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

Guest

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]
 
G

Guest

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]
 
G

Guest

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?
 

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

Top