Printing one record per page (Counter?)

[Agnus]

I have a report based on a query. It is used to bill private tutors for work the agency has found them. Obviously one tutor tutors many students. The report should be formatted so that there is a page break at the end of each tutor's record. It works fine, but I can not get the report to have a page break where I want it, and so is useless as a document to the agency. MS Help says that a conditional page break can be inserted thus:

If Me![Counter] = 1 Then
Me![PageBreak1].visible = True
End If

(the page break control having been set to visible.false in the PageHeader_Format procedure.)

All that happens is a message saying "Access can't find the field 'Counter' referred to in your expression".
I can't find Counter in the help files, apart from in the code given above, and it is not a control. I have grouped the records together in the Grouping and Sorting dialog, but tis is making no difference at present.

I have also tried during this kind of thing via a form, but no joy yet.

Any help much appreciated, thanks.

 

[andrewvanbeck]

Try using grouping instead of page breaks, they allow you to group by your key field, or any field for that matter, and you can set your grouping so that each record has its own page.

HTH

Andrew.

 

[Agnus]

I have tried the grouping and sorting thing. No joy, I'm afraid. The report is still printing more than one tutor and thier students per page.