Subreport criteria selection

[jaw5]

I have a school report that I want to run by grade which shows the credits the student has earned by category and this works fine. I added a subreport to show the currently scheduled courses, but the only one that prints is the one for the first student. In the SQL profile for the subreport, it says a snapshot was created and the only student selected is the first one. In the subreport, I defined the student ID = Main query student ID. Is there a way to make this work correctly? (The courses table that I get the credit hours from is a different table from the one I had to use for the scheduled courses.)

Thanks for your help.