Close Report W/O Saving Changes

[thisisntwally]

I've found a few other postings with this problem, but none seem to have come to a solution.

I have a dynamic report, the guts of which are filled in from controls on a form.
As the field names, visiblity and sources are set new each time the report is run, I need to be disable the msg asking Users if the want to save.

a. if i set msg to false access's default is to save, ergo NO GOOD

b. the following 'DoCmd.Close acReport, "Test1", acSaveNo,'
promts a 2585 error 'this action cannot be carried out while processing a form or report event', saves, and closes the report, ergo NO GOOD

Does anyone have any ideas whats wrong with option B? Or any suggestions on how else i might go about this?



edit: this doesn't work either 'DoCmd.Close ObjectType:=acReport, ObjectName:="Test1", Save:=acSaveNo'

 

[thisisntwally]

survey says

Not that anyone has even looked at this, but my interweb research seems to imply that there is NO WAY to block the save changes msg if the report is closed with the X. That being said, im going to open a tiny little form along with my report, with a button to close the report, and disable the X.