Report errors

[SuperSlick]

It has been awhile since my last post. I would like to thank everyone for giving the solution for my issue.

I have a report that gets data frim a query. In the event that the query does not find any records, I get an error.

It doesn't find the fields because there are not records. It works perfectly when data is found by the query.

Please help.

 

[ypma]

Have you tried to enter a message or cancel in Properties of the report On No Data EG

Private Sub Report_NoData(Cancel As Integer)
Cancel = MsgBox("No records found ", vbInformation, Me.Caption)

OR just cancel = true
End Sub

 

[SuperSlick]

Thank you so much. That worked.

 

[ypma]

Thank you for the positive feed back . If you could now mark the post as solved ,if you are unsure how to do that, Search under Solved and you will see Jon's post of how its done .

Regards