Move Next Page in Report using Code

[Ken Chan]

I am using recordset to get data and draw line chart.

Is there a way to advance to next page in report to plot my next data?

1) Report : unbound
2) Not using Chart Wizard

Regards.
Ken

 

[Alex Dybenko]

Hi,
I think you can try to bind your report to some 2 records table or
recordset, then you will get 2 pages and use format event to plot your graph

Or you can insert a page break - then you also get 2 pages

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Ken Chan]

Hi,

Records can range for hundreds, and I have design in detail, think page
break cannot work for me.

Is there code to advance to next record in report?

Thanks.
Ken

 

[Alex Dybenko]

Hmm,
what do you mean then with "advance to next record"? Well, perhaps you can
just use detail section format event to run your code. you can't refer to
other pages, but you can refer to a recordset report based on, and locate
there required record.

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com