Unique Report Pages

[gschimek]

Is there a way to have a report where page 1 is different from page 2, which is different from page 3, etc. I have a 5-page paper form that I want to recreate within Access so that it's filled out automatically. But I don't know how to do anything other than a report where each page has the same layout.

 

[boblarson]

Use sub reports

 

[gschimek]

OK, so that was a lot easier than I thought. Thanks. But now I have another problem with that report. When I open the report, I do it with a command button that uses this code:

Private Sub Form1_Click()
Dim strReportName As String
   Dim strCriteria As String
   
   DoCmd.RunCommand acCmdSaveRecord
   
    
   strReportName = "rptForm1"
   strCriteria = "[FirstName]='" & Me![FirstName] & "'"
   DoCmd.OpenReport strReportName, acViewPreview, , strCriteria
End Sub

Normally that restricts the data for the report to just the 1 record that I'm viewing. Now that I've added subreports to the bottom of my main report, those subreports are not being restricted. Instead they're showing all the data in the report.

How can I restrict the subforms to the data I need?

 

[boblarson]

Make sure the sub reports are linked to the main report in some way. What key field could you use that would link all of the reports together?

 

[gschimek]

Here's the layout of the report(s). Page 1 has a lot of data from the database on it, and that page works fine. Pages 2 and 3 only have a picture on them--no data from the database, so those are of course not an issue. Pages 4 and 5 only have 1 text box on them. The text box is also on page 1 of the report, so that would be the one to link to, I suppose. All the reports are all pulling data from the same query, though, so where would I put a link?