Multiple Pages

[dadrew]

I have a form which produces a lot of data. I now want to put that data into a report. I would like to design the report to be laid out on a number of pages and then print it from a single click. Do I have to create a report for each seperate sheet or is there an easy way. I'm sure there is!

 

[Ukraine82]

Are you saying that you have to many fields it will cause your report to print so many pages or you have so many records that you wish to print only current record from a form in a report?

Michael

 

[dadrew]

Basically I have a number of fields and I want them to be spread over a number of a pages. Ideally I want to achive this without creating seperate reports.

 

[Ukraine82]

I'm not sure if it helps, but my database has 2 reports(18 fields each) from 1 form(36 fields).

I'm using the command buttons on my form to print Page 1 report for first 18 fields or print page 2 report for my last 18 fields. If you wish to do it my way than try pasting this code in a form.

Dim strDocName As String
Dim strLinkCriteria As String

strDocName = "ReportName"
strLinkCriteria = "[FieldName] = Forms![FormName]![FieldName]"

DoCmd.OpenReport strDocName, acNormal, , strLinkCriteria

hth,
Michael