Only print a maximum of two records on a sub report...

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

I have a report that contains the detail of a task and has a sub report
that lists the notes for that task. I would like to have only 2 of the
notes included on the report. Can anybody point me in the right
direction to get this to work?

Thanks,
Kevin
 
Add a text box to the detail section of the subreport:

Name: txtCountMe
Control Source: =1
Running Sum: Over All
Visible: No

Then add code to the On Format event of this section:
Cancel = Me.txtCountMe>2
 
Back
Top