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.

"Gntlhnds" wrote:

This is what I am trying to do. I have a form whose source is tblStudents
with a combo box that selects the student. I then have a subform whose
source is tblCourseGrades as a datasheet. I have two field, Course and
Grade. Course is a combo box with tblCourses as it's source to select the
Course. This is not working for me, though. Becasue tblCourseGrade does not
have a Course field, I have to have the combo box unbound, which does not
work. If anyone has any idea as to how I should properly setup this subform,
I would greatly appreciate it. Thanks.

"John W. Vinson" wrote:

On Fri, 23 Apr 2010 07:48:01 -0700, Gntlhnds
wrote:

Thanks for the response. The best way to describe my situation would be like
an elementary school, where each class takes the same courses at the same
time. And, no, my tblCourseGrades is not populated with the courses and
students. I'm assuming I would use a query to do this, but how would I work
that? I have classes starting about every two weeks or so, and each class
takes the same courses, so I would need to frequently update that table. I
hope this is enough information. Thanks.

A Query probably will be involved, but you would (I would guess!) need to pick
somebody's brain for the information that Alisia Gonzalez is assigned to the
Management Development class starting May 3. Normally one would do this using
a form and subform arrangement; this could be done in two ways - you could
have a form based on the table of students with a subform based on what I'd
call the "class enrollment" table, allowing you to pick whichever classes this
student needs. Alternatively (or in addition) you could have a form based on
the class table, with a subform allowing you to pick students from a combo box
to enter them into the enrollment table.
--

John W. Vinson [MVP]
.