Access a reports record source

[bbulla]

Hi,

I have a report that is based on a query. What I want to do is read the next record in the query before the report has a chance to write the record in the detail section. This way I can insert a page break (pagebreak.visible = true) depending on what the next record is.

How do I access the next record while it is still on the current record?

Thanks,

 

[bbulla]

I found an alternate solution. See: http://www.access-programmers.co.uk/forums/showthread.php?t=165336