subtotal in a continuous form

  • Thread starter Thread starter pbuscio
  • Start date Start date
P

pbuscio

Hi

I have a continuous form that is being filtered and I need to subtotal
the count of the filtered data. Can anyone help? I have tried using
Dcount but that just gets me the grand total. I have tried using
strCount in the code of the combo boxes used for filtering but that
just leaves the text box blank.
 
Use a footer in the subform and set the controlsource to:

=Count([Your Field Name])
 
I have a continuous form that is being filtered and I need to subtotal
the count of the filtered data. Can anyone help? I have tried using
Dcount but that just gets me the grand total. I have tried using
strCount in the code of the combo boxes used for filtering but that
just leaves the text box blank.
Click to expand...


A text box in the form's header or footer section can
display the count of records by using the expression:
=Count(*)

If that does not reliably provide the total count of subform
records, then add the line of code:
Me.RecordsetClone.MoveLast
in the form's Load event and immediately after you reset the
form's Filter, RecordSource or a Requery
 
Back
Top