SubReport Only Displays on Page

[swicklund]

I have a report that is generated based on critera I enter in a form. There is a subreport within the report, and no matter how many records that should be in the subreport, it only pulls up enough to fill one page.

See code below for opening report:

Dim stDocName As String
Dim Criteria As String
Dim tempString As String

stDocName = "ProjectsRpt"
tempString = Me!ProjectName
Criteria = "[ProjectName] = '" & tempString & "'"
DoCmd.Close

DoCmd.OpenReport stDocName, acPreview, , Criteria

I ran a quick query to verify the number of records based on my criteria, and got the 23 records I was expecting.

Any ideas??

 

[THWatson]

swicklund
Try removing the DoCmd.Close command line.

What is happening, I suspect, is that the form is closing before the report gets a chance to pull the second page of records.

Tom