Show/Hide Report

[expublish]

I have a report that is based on a query that filters out people, who's birthday it is in the next 10 days.

Now, I want this report to only open if there is data in it. I.E If it is no-ones birthday in the next 10 days, do not open. Otherwise do open.

I assume I need to put some code in the On No Data event of the report. Anyone know what this is?

To summarise - code needed to stop report opening if no records.

Thanks

Scott.

PS - I have setup a form, so that when it is opened the report opens.

 

[Rich]

Please continue with one thread, you've just been given the answer.