Wow that was quick and works perfect on your form. However, I guess I have built mine differently, because when I change your form to a Continuous form I get an error message
View attachment 100930
So my form (fAccListMSLB) is based on a query that has two tables joined together.
* The parent table is tAccLog and the unique key is tSpcID.
* The Child Table is tAccSpc with a unique key tSpcID and the linking field is tAccNoLink that contains the same value as tAccId in the tAccLog.
For every Record in tAccLog (Parent) there is one or more records in the tAccSpc (Child Table).
The Form is a continuous form that allows the user to see every record record in the tAccSpc and the Name, Provider and Staff Processor of that specific event from the Parent Table and also the details of the actual event from the Child Table.
So I have 8,956 in tAccLog (Parent) and 18,539 records in tAccSpc (Child)
The User is presented with 5 Multi Select List boxes that allow them to filter the records to get exactly what they want by click the values that correspond with their need, for Example, they may just want to see the Year 2021 and say the 2nd quarter, so they click 2021 in the year box and April, May and June in the Month box, and then they only want records for the Provider Name John, they click him and the staffer that recorded the event, maybe Jane. So now there are only 387 total records for the tAccSpc (Child) table, which I get by simply using the =Count(*) but there are only 42 unique Parent records. for the 387 child records... So... counting the Parent records is my struggle. I had thought initially that I could just create an unbound text box and do something like "Count(tAccNo)" but that still counts 387 records because for each child record it shows the tAccNo for them. So then I thought I could somehow count only the first occurrence of each tAccNo... but so far, nothing is working.
So perhaps this is a better explanation and can give you a better idea of what I was trying to do. But let me say a BIG THANK YOU for that example that you sent! It was above and beyond the call of duty on your part!!! ☺