Disabling prompt to save changes to the layout of a query

P

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
 
J

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?"
Click to expand...

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.
 
Top