How to show "No Result" Page when there is no record.

[Sianboy]

Hey I got a school IT project and encourtered this problem hope you all can help me
I have completed my form, query and report le. But problem is, if I want to show a report that tells the users there is no records found, how am I support to do it? Currently my report only shows all results regardless of what, including blank report if there is no record.
The suggestions provided should be as simple as possbile as non-sql users here who know only a bit. A help is greatly appreciated thanks!

 

[John Big Booty]

You could use something like;

If Me.RecordSet.RecordCount = 0 Then
    MsgBox "No records"
End If

Try it in the On Load event .