How to disable "Do you want to save changes to the design of form"

[dhlao]

I've a main form name "FormA" with Navigation subform. Its Navigation button are target to the other form, I call these forms "FormB".
These "FormB" has a subform inside. I call these subform "FormC".
These "FormC" are all set to Datasheet View.

User open "FormA". They can see these "FormC" and adjust its Datasheet column width.

The problem is when change has made and user click another Navigation button, a popup "Do you want to save changes to the design of form..." prompt.

Is there a way to set the default to "NOT SAVE" and don't prompt this message to user ?

I've try "DoCmd.Close, acForm, "form_name", acSaveNo" in Form_Close event. But it said the close event cancel.

And I don't want to use "DoCmd.SetWarnings False"

 

[Ranman256]

Yes ,it IS set warnings false.
Why ignore the correct answer?

 

[dhlao]

Hello Ranman256
But SetWarnings to False may hide the other warning message.
Correct me if I'm wrong.