Counts records in a subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to place the total number of records in my subform in a field on
my main form. I have tried addind a field to the subform that has a default
value of 1 and then running on a sum on those but I just get an error. Any
suggestions Thank you
 
replace it with a Control in the footer of the Subform

Control: SubCount, ControlSource: =Count(*)

On The Main Form
Control: MainCount, ControlSource: =Forms!MainForm!SubForm.Form!SubCount

Make sure you refer to the ControlName of the SubForm on the MainForm, which
isn't neccessarily the same as the name of the subform

HTH

Pieter
 
replace it with a Control in the footer of the Subform

Control: SubCount, ControlSource: =Count(*)

On The Main Form
Control: MainCount, ControlSource: =Forms!MainForm!SubForm.Form!SubCount

Make sure you refer to the ControlName of the SubForm on the MainForm, which
isn't neccessarily the same as the name of the subform

HTH

Pieter



Jason said:
I would like to place the total number of records in my subform in a field
on
my main form. I have tried addind a field to the subform that has a
default
value of 1 and then running on a sum on those but I just get an error. Any
suggestions Thank you
Click to expand...



--
 
You must log in or register to reply here.

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

Similar Threads

Parameter Value error in a Subform 0
If query/subform is empty set calculation value to 0 4
Counting in subform 1
Problem with form--subform 5
Count Records in a SubForm 1
Subform Question 2
Open form for record selected in subform 2
Access Daily Entry with multiple entries per field 0

Back
Top