Running several indiviual reports

[BatmanMR287]

I have an individual report that runs on each person from a district. On each row of the table is an individual and all data needed to run the report. Everyone from the same district has the same district number. I need to pull up a district and run the report on all people from that district. How do I make the report cycle through each person from that district and print a separate report for each person?

[June7]

Options:

1. print one report with page breaks after each person - no code required

2. print multiple reports with filter criteria - requires VBA code to loop through a recordset of people ID, something like:
Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("SELECT ID FROM table WHERE District=" & Me.cbxDistrict)
rs.MoveFirst
While Not rs.EOF
DoCmd.OpenReport "reportname", , , "ID=" & rs!ID
DoCmd.PrintOut
DoCmd.Close acReport, "reportname", acSaveNo
rs.MoveNext
Wend
rs.Close

This assumes each person is unique in the table and ID is the unique identifier for each person.

[BatmanMR287]

Got that to work perfectly. ID is unique identifier. Thanks June7.