I have a main form, with a sub form, linked by ClientID. I would like to have a text box in the subform to display the count of records within the subform that meet one criterion.
Main form - Clients, PK ID
Subform - Appointments, PK AppointmentID, FK ClientID
I would like the text box to show count of AppointmentID where Attendance = "Attended".