Show most recent from Subreport

  • Thread starter Thread starter Robbie Doo
  • Start date Start date
R

Robbie Doo

Thank you Duane for all your suggestions.

A while ago you made this suggestion for a regular report. I'm just
wondering if it's possible to use the same for info on subreport. Here's the
copy of the suggestion that works perfectly on a report.

Group your report by ProbItemNo with a group header. Sort next by CallDate
Descending. Add a text box to your report's detail section:
Name: txtCount
Control Source: =1
Running Sum: Over Group
Visible: No
Add code to the On Format event of the detail section:
Cancel = Me.txtCount>1

Thanx in advance.
 
Back
Top