reports

[orent]

hello
i open a report from button code :
docmd.openreport "qry",acPreview
MY QUESTION IS:
how can i know if the record is empty?
what should i write in the code event of the button to know if the report(return record) is empty???
i know that there is in the design of the report 'nodata' event
i want to know if is null from the button code of the form
thanks

 

[dhookom]

If you want to know before the report opens, use code like:
If DCount("*","qry&quot > 0 Then
DoCmd.OpenReport ....
End If

Duane
MS Access MVP
Find out how to get great answers faq219-2884.