Show a pop up box when report shows null values returned

[John_Westham]

Hi,
basically I have a report based on a qry where someone will enter a postcode to return all values linked to it. I need a pop up box to appear when this qry is run in a report and no matching postcode is found. Just so I can redirect the user to another report.
Any help will be apreciated.
John.

 

[maikon]

Did you try something like:

Sub Report_Load()

If Report = Null Then
OtherReport.Show

End Sub

It's an idea..........

 

[BarryMK]

You could use the report's On No data event

 

[Rich]

Why would you have another Report that might have the postcode?