1 the bill has <10 records,
2. bill has =10records,
3.bill has >10 records.
the detail.forcenewsection=2 works fine with serial mod 10= 10 with if else statement . in 1 and 3 cases. but when there are exact 10 records, the report footer section goes to next page. .. I tried several if then else, if else select etc but noted that only first selection statement works then access' goes to sleep. I think access is lazy like me? Respected sir, I doubt I am missing something great. I am creating this great app for humanity. kindly show me the way.
regards.... Er. Kamal dev
code goes as:
Expand|Select|Wrap|Line Numbers
- in "report_page()" event===>
- if serial mod 10 =0 then
- detail.forcenewsection=2
- else
- detail.forcenewsection=0
- end if
- end sub