This part of my project is basically a way to track daily grades for multiple students in several different target areas. What I would like to be able to do is open the grading form and have it based on the studentID and grouped by GradingDate with a subform that has all of that students target areas pre populated(by currently active targets) so I just go down the list and plug in the scores and comments.

So I have:

tblStudents:
#StudentID
FirstName
LastName
etc

tblTargets: Several students may use the same Target but not all and some may be unique to one student
#TargetID
TargetName

tblStudent and Targets:
#ID
#StudentID
#TargetID
Current - yes/no To tell if a student is being graded on this currently

tblPoints
#ID
#StudentID
#TargetID
ScoreDate To keep track of daily scores
Score Combo box to select 1-5
Comments To comment on why they got this score if needed

Hope this makes sense. Thanks for any help you can offer.