Disabling prompt to save changes to the layout of a query

[Pat]

Does anyone know how to disable the prompt that a user
receives after changing the column widths of a query that
is linked to a subform? After changing column widths and
when closing the form, Access asks "Do you want to save
changes to the layout of query?"

Thanks in advance for any help.
Pat Norman

 

[John Vinson]

Does anyone know how to disable the prompt that a user
receives after changing the column widths of a query that
is linked to a subform? After changing column widths and
when closing the form, Access asks "Do you want to save
changes to the layout of query?"

You might want to use a Close button rather than closing the form with
the X, and use

DoCmd.Close acForm, "your-form-name", acSaveNo

in the button's click event to explicitly NOT save design changes.