Loops and Textboxes

[echorley]

I have a report that has two subreports that are built upon seperate queries. I preview this report by selecting a student from a textbox and Access creates the student's "Progress Report." Both queries that the subreports are built on have their Student Name criteria set to the name that is selected in the text box.

What I am looking to do is loop through all of the students names so that I can print all of the "Progress Reports" at once. I have found code on the forum for the loop, but I do not know how to change the name in the textbox each time through the loop. Thanks.

 

[Rich]

Remove the criteria from the underlying query, no code is required just to print all the Records unless you want to be able to select the value All from a list box

 

[echorley]

When I tried that

I got a bunch of pages with the first subquery and then a bunch of pages with the second subquery all together. I am sure I can put page breaks in , but I could not get the two subqueries to print on the same page with that student.

 

[Rich]

Are the Master/Chield fields linked?