subtotal in a continuous form

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.
 
A

Arvin Meyer MVP

Use a footer in the subform and set the controlsource to:

=Count([Your Field Name])
 
M

Marshall Barton

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
 

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

Filtering data from a non-continuous list 3
DLookup in Continuous form 0
Clearing combo boxes and a text box 2
Dynamic Naming of Form Button 3
Macro Pause to Select range then Subtotal 0
Creating a Search using a combo box and then creating a report. 4
Getting Text data using the Data - Subtotal feature 1
Macro Loop 0

Top