Good day team,
Please i need help on how to resolve an issue on my report. The report querry is coming from a querry generated from main and subform. The report page fails to break in to another page whenever the data value generated from the subform is more than 10, it rather start numbering 11 and 12 from the top. I have but no solution.
I need a possible VBA script that can create a page break whenever the value is more than 10.
Find below a screen shot of the result that i am getting.
https://snag.gy/tquoWJ.jpg .
Thanks in advance for your assistance.
Please i need help on how to resolve an issue on my report. The report querry is coming from a querry generated from main and subform. The report page fails to break in to another page whenever the data value generated from the subform is more than 10, it rather start numbering 11 and 12 from the top. I have but no solution.
I need a possible VBA script that can create a page break whenever the value is more than 10.
Find below a screen shot of the result that i am getting.
https://snag.gy/tquoWJ.jpg .
Thanks in advance for your assistance.