Display number of records on a subform

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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]
 
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]
 
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

Back
Top