In the video about Tracking student attendance, there are several references for which I would like more information.

How can I sort the list by homeroom using a combo box? I've tried several things with no luck.

How do I advance the date by one?

And, finally, is it possible to clear or reset all of the yes/no boxes once the "go" macro has been run? Again, tried all the tricks I thought would work.

Thanks in advance...I'm so glad I came upon this tutorial as it will save me TONS of time!

---

Reply from Alex Hedley:

You want to pick a value from a combobox to sort the form?

Do you want a button on the form that you click and add 1 to the date?
DateAdd

Checkboxes

Dim chk As CheckBox
Dim Ctl As Control

For Each Ctl In Me.Controls
  If Ctl.Properties("ControlType") = acCheckBox Then Ctl = False
Next Ctl