Hi
I hope someone can help me on this.
I have a subform that is filtered from the main form by department or student, when I filter by department I want it to show the total number of ticked boxes in the footer of the subform.
I have the following
Code:
=Sum(IIf([tbc]=True,1,0))
in the controlsource for the box which is in the footer of my subform, however it reads zero until the ticked boxes are visible on the form and then it shows the total, in this case three. I have checked the subform properties and the code is working so have run out of ideas as to how to get this to work.
Thank you