Report cancel on no data in detail section

[caniread]

Is there a way to cancel the report if no data exists in the detail section only? I have it working in another report but I think my header technically has data so it doesn't cancel the report. Code I used is below.




Private Sub Report_NoData(Cancel As Integer)
MsgBox "There are no open ideas that match your selection(s)"
Cancel = True
End Sub

[rpeare]

if a query is driving your report and you are calling it from a button click or other event

for instance

if dcount"*", "SourceQuery") = 0 then
    msgbox "no data for this report"
else
    docmd.openreport "reportname"
endif