Auto close a report if no records returned

[beatleman]

hi all, in code, how to do i make a report close automatically if it detects no records are contained within it. The report is generated from a query. thanks

 

[KeithG]

look at the On_No_Data event

 

[boblarson]

check out my response on this post for some code for the No Data event:
http://www.access-programmers.co.uk/forums/showthread.php?t=125834