Print 1 report for each record

[brownti via AccessMonster.com]

I have a report based off of a select query. Criteria for this query is
selected in a form (the criteria is roomnumber) and then the report is
displayed for that room number. In the table that stores room number i also
have 'wing' there are roughly 10 rooms per wing and 16 wings. i would like
to print all room reports for each wing without having to select each room
individually. does any one know of a way that i can print one report for
each room in the selected wing? Maybe there is some VBA to cycle through all
records with wing criteria selected and print a report?

 

[John W. Vinson]

I have a report based off of a select query. Criteria for this query is
selected in a form (the criteria is roomnumber) and then the report is
displayed for that room number. In the table that stores room number i also
have 'wing' there are roughly 10 rooms per wing and 16 wings. i would like
to print all room reports for each wing without having to select each room
individually. does any one know of a way that i can print one report for
each room in the selected wing? Maybe there is some VBA to cycle through all
records with wing criteria selected and print a report?

Use a criterion on the wing (or whatever field or fields you want to use)
rather than a criterion on the roomnumber.