Report where clause problem

[moonbase]

In a form I allow selection of a record in a table. I then openreport with a where clause e.g.
DoCmd.OpenReport "rptTenantEnquiry", acViewPreview, , "lngTenID = " & CStr(Me.lngTenID)

This works fine with a few records but with a large number of records the report is blank (just headings). Has anyone come across this?

 

[JoeAtWork]

I have seen this behaviour when the report's properties cause the details not to appear until the second page. I can't tell you off the top of my head which properties to look at, but look for anything that might be causing it to try to keep all the records on the same page.

For example, I have seen this in reports where the page was originally supposed to be on Legal size paper, but somehow the settings got changed to Letter size.

 

[dhookom]

What do you see if you take a value that returns a blank report and enter it as a criteria directly in the report's record source query?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[moonbase]

Thank's for your help in pointing me in the right direction. The problem is now solved. As is usual, the chief suspect was not guilty. The problem was caused by the record source query 'top values' property being set to 100.