close a specific report with VBA

[fritz]

I have an open report on the desktop and want to close it with code. Can anyone help?

 

[John Big Booty]

Try;

DoCmd.[URL="http://msdn.microsoft.com/en-us/library/aa212263%28office.11%29.aspx"]Close[/URL] acReport, "YourReportName"

 

[vbaInet]

You might also want to add acSaveNo to the third of that method so design changes aren't saved. It's not vital but worth having.

 

[fritz]

Thanks a lot.