Can't update fields in query

[stormin_norm]

Okay. I reversed my logic and started with the most constrained query and then joined to the student table. Basically reversing the join sequence in the previous test queries.
All works wonderful now.
Thanks for your assistance Pat and Ancient One!
I have to agree with Real Knotty on the 2+ query principle. Whenever there is a complex join you need break it up if you want to update the data vs. display complex join results (reports).

This cost some time with a lot of experimenting, but well worth it.

Here is the solution:

qryCourseMGT100Grade:
SELECT Course.*, Grade.*
FROM Course INNER JOIN Grade ON [Course].[CourseID]=[Grade].[CourseID]
WHERE ((([Course].[Course])="MGT100"));

qryCourseMGT100GradeStudent:
SELECT Student.*, qryCourseMGT100Grade.*
FROM Student LEFT JOIN qryCourseMGT100Grade ON [Student].[StudentID]=[qryCourseMGT100Grade].[StudentID]
WHERE ((([Student].[Class])="100"));

Result:
1 Smith Jane 100
2 Richards Mary 100
4 Baker Scott 100 1 MGT100 Intro 1 4 1 A