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

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
 
D

Duane Hookom

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
 
Top