I'm not sure why this wouldn't work, but it only closes the first report then exits the loop.
Code:For Each Report In Reports DoCmd.Close acReport, Report.Name, acSaveNo Next
I'm not sure why this wouldn't work, but it only closes the first report then exits the loop.
Code:For Each Report In Reports DoCmd.Close acReport, Report.Name, acSaveNo Next
Do you have only 2 reports open? This might have explanation http://www.techrepublic.com/blog/mso...-database/1662
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
That's it exactly!