Would you mind clarifying what you mean by modifying the query def?
And another point I have...When i step through the code line by line, when I execute the openreport method, the report shows in access with no filter applied. I feel like this is wrong.
Thanks again for the quick replies.

I have an Access report that looks at students in specific high schools and gives their schedule. At the moment it is a 150 page report, for about 100 unique high schools. I have it set up at the moment to output the report as a PDF. (Some high schools take up several pages of the report due to more students.)

What I want to do is, using VBA, I'd like to split the report up by high school. One pdf for each school. The following is...