disable report save

[raymond3090]

This was a previous thread originally posted by LIndaG. I have the same problem but the replies haven't been able to help me. I tried to email LindaG to see if she was able to figure it out but I haven't received a reponse.

Here's the problem (in Linda's words):

I have a report that gets modified in design view (the only way I can figure out how to access the report width) conditionally. The problem is that I don't want the user to be able to save this report when it is in print preview. If the close button (the one for the print preview window next to the maximize/minimize buttons) is clicked, Access prompts the user to save. If I use docmd.setwarnings to false, Access will opt to save as that is the default. Is there any way to disable this prompt and not have the report save? My only other option is to create two nearly duplicate reports, which I really don't want to do as I don't want to maintain two reports. Any suggestions are welcome.

Any help would be very much appreciated!!

 

[llkhoutx]

Set the appropriate openreport field to not save and set "setwarning" to "False" before the openreport is executed. Be sure to setwarning to "True" after the openreport.

 

[raymond3090]

thanks for the reply llkhoutx!

I don't really understand what you mean though. Why would I be concerned with openreport if all I want to do is close the report without saving nor prompting to save? In addition, does openreport even have a field that allows me to specify saving properties? I thought it was just the report name, view type, filtername and wherecondition.

thanks,

-ray