Show most recent from Subreport

[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.

 

[Duane Hookom]

Did you try it? I would. I expect it should work if done correctly.