I have a Form with a collection of subforms (continous) Each subform is one Calendar Day. I have three unbound text boxes on each subform first is txtEnrollers this number is input by the user. txtCount =Count(*) the last one is txtOpenAppointm ents =(([txtEnrollers] * 23) - [txtCount])) Which Gives Me the number of open time slots for that day. The subform Contains 4 four columns
[CTRL NUM], [APPT TIME], [BIOMETRICS STATION], [APPT DATE]...