Hide Some Detail Records - Acc 97

[gregoryagu]

I have a report which runs year to date, so I can get summary information. However, the detail section shows all records. I need it to show only records after a certain date. So for example,

if Forms!frmCriteria.txtStartDate > [MyDateField] then
' Don't show this detail
else
' Show this detail.
Endif

Is there a way to do this?

Greg

 

[gregoryagu]

Got it.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If [DateOfAbsence] < Forms!frmAttendanceCriteriaByDateRange!txtRangeStartDate Then
Cancel = True
End If
End Sub