I have followed the Student Attendance Append Query video and have managed to get that working 100%.  The difference between what I am trying to do and the video is entering attendance for different classes on a daily basis based on the same student list.  I would like to have a drop down in the header/footer that would work the same way as the date field so that once the action query (append) is run, it adds the date that the student attended the class.  I have it to a point now that the drop down is there, but it is only selecting the class for the row I am currently in - not for the whole student list.

---

Reply from Alex Hedley:

See this tip: Combo Box Default Value