On Fri, 23 Apr 2010 09:55:01 -0700, Gntlhnds
wrote:

Really what I would like is to have the subform list all of the courses with
the ability to add the grade once the student completes the course, then I
can create reports to output the grades either by student or class, including
a composite grade.

Don't confuse data *DISPLAY* - a subform - with data *STORAGE* - a table.

Data is NOT stored in forms. It's stored in tables, and only in tables. You
can display multiple courses on the form if you like, but it sounds like
you're assuming that the grade is being put into the form. It's not; you're
using the form as a tool to put the grade (and the student ID and the course)
into a Table. You can then use queries and reports to pull the data back out
of that table in any form or combination you like.
--

John W. Vinson [MVP]