vba to close report without name (1 Viewer)

[John thomas]

Hi is there a way to use vba to close the currently open report on the screen without specifying its name
Thank you

 

[vbaInet]

If it's the only report opened then:

    DoCmd.Close acReport, Reports(0).Name, acSaveNo

If there are several reports opened but you want to close the active one then:

    DoCmd.Close acReport, Screen.ActiveReport.Name, acSaveNo

 

[John thomas]

Hi
Thats exactly what I need
Thanks for your help
John

 

[vbaInet]

You're welcome.