Form prompts to save changes each time I close it

[MichaelWaimauku]

I have a pivot chart query that is inserted into a form. The user can choose to print that form or close. If print is chosen, printed and then the exit button used, a dialog box always prompts: 'Do you want to save changes to the layout of query 'Supplier Issues per Month Pivot Chart Query?' It only occurs if printing. How can I stop this from happening?

 

[bsacheri]

If you have a button on the form that users click to close it, and your query is being displayed in a subform object, then add this to your close event:

Me.subform.SourceObject = ""

If you don't have a Close button, then I don't know what to suggest. I'm running into a similar problem. If the user closes the form with the Access "X" button, I get the annoying message before any trappable events fire. :banghead:

Your post was a long time ago. I'm curious if you ever found a solution.