cannot advance using nextRecord in report

[arage]

the below code is meant to advance to the next record if the current record does not have date data that corresponds to today’s date. This way I only get a report that has detail records entered on the system date. Currently I get an invalid use of property, can anyone explain why?

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.DateSentToAccounting <> Date Or Me.DateSentToJon <> Date Then
Me.NextRecord
End If

End Sub

 

[BillR]

Why don't you create a query with 'date' as the criteria for the key field for your report. Change the data source for your report to the query name.