Report not closing but going into design mode

[jimlee]

As the title suggests, when I click on the close button in the report preview the report reverts to design mode, this has only started happening since i added some code to the On Close event (now deleted), can anyone help?

Also, is there any way to stop the report from prompting the user to save the changes made when closing down? The recordsource of the report is changed programatically when the report is opened which causes this to happen (could be something to do with the first issue too?)

As usual, any help or suggestions greatly appreciated

jimlad

"There's this thing called being so open-minded your brains drop out." - Richard Dawkins

 

[jimlee]

I found out how to stop the user being prompted to save when closing. I simply put docmd.save in the 'On Open' event procedure.

I still haven't figured out how to stop it going into design view when clicking the reports close button though.

(I think it has something to do with the fact that I set the forms recordsource and filter from the calling module after the report has opened but i'm not sure.)

Anyone have any suggestions?

jimlad

"There's this thing called being so open-minded your brains drop out." - Richard Dawkins