STOP: Do you want to save changes to the design of form 'Chart1'?

[jerem]

How can you stop this prompt? I have checked everywhere on internet and cannot find an answer!

I have a Navigation Form in Access 2010. First page has two subforms: Datasheet1 and Chart1.


Whenever I click on another tab of the Navigation Form I get the mentioned prompt! (unless I do a control+s before)

I have checked everywhere but can't seem to find. Some suggest to use the DoCmd.Close + Saveno but it doesn't apply here since I am not closing anything. Another was suggesting a code using .SetWarnings False but it doesn't work either.

Any genius who could give me an answer?
Thank you!

[RuralGuy]

With those names for your forms it sounds like you do not have much developed yet. Why not do a Compact and Repair and then ZIP up the db and attach it to a post with the GoAdvanced area? Maybe someone will have time to look at it.

[jerem]

The forms have different names. I changed them in the thread for the sake of clarity. Now you know that my first subform is a datasheet and the second is a chart. I have done compact and repair. I have also re-created the chart1 form in case the form was corrupted but nothing helps.

[jerem]

Alright! The solution was to insert the code

DoCmd.SetWarnings False

in the On Open event for all the Navigation tabs. I don't have warnings anymore but since I created my own warnings to restrict the user, it doesn't really matter.

[RuralGuy]

Thanks for posting back with your solution.