The cosmic perspective reminds us that in space, where there is no air, a flag will not wave - an indication that perhaps flag waving and space exploration do not mix.
I have watched both video's of Count and Dcount. I used one of them in my continuous forms. There is no filter on at that moment. I created a unbound field for it. For now I made a simpel option in the controle source like this: =DCount("[specific_field]"; "Queryname"). (That query filters related fields between 2 tables using a value on the main form.) Works fine. However I want to know the number of records (in the subform) whatever filter the user sets on the subform and not just the number of records. How do I fix that?
Kevin Robertson
@Reply 3 years ago
In the Footer of your Continuous Form add a Text Box.
In the Control Source of the Text Box add: =Count("*") This will count the number of records in the current Recordset (showing on the Form).
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
