Run-time sorting causing "Save changes" dialog

when the user moves to another form, are you closing the first one?  If so, there is a parameter that can either save or not

'close and don't save
DoCmd.Close acForm, Me.Name, acSaveNo

'close and save
DoCmd.Close acForm, Me.Name, acSaveYes

you can also try setting AllowDesignChanges to false, which you can do in code before you sort:

me.AllowDesignChanges = false

Select allOpen in new window

you can also set this for the form before YOU save and distribute it.  Although this option no longer shows on the property sheet, it can be set through code.

Alternately, you can:

DoCmd.SetWarnings False

Select allOpen in new window

and then open other form and then on its open event:

DoCmd.SetWarnings True

Select allOpen in new window

However, using AllowDesignChanges would be preferable.

I've been trying some of the suggestions.    It's not working for me.

I am reluctant to  mess with the DoCmd.SetWarnings =true /false commands because this would block all warnings.

I even tried the following, but still get prompted when go from one tab to another on the navigation control.

Me.OrderBy = "[StockNum] ASC": Me.OrderByOn = True:
DoCmd.Close acForm, Me.Name, acSaveYes

Select allOpen in new window

Since this is a Navigation control, there are things going on behind the scenes ... is there anything the user changes besides the sorting?

The user is given the option to see the continuous form by incrementing [stock number] or by [Record ID] which is "no sort".

For testing purposes, I put the sort command in the Form Load event.   The sort works fine.

I would be ok with disabling warnings with one command between the "Off" and the "On".
I am less comfortable in using this command on a form close event.

If I rem out

Me.OrderBy = "[StockNum] ASC": Me.OrderByOn = True:

Select allOpen in new window

 then everything is fine.
If I activate that same code, and then use

DoCmd.Close acForm, Me.Name, acSaveYes

Select allOpen in new window

, the problem is not resolved.

Microsoft Access determines that the  design of the form is changed when I do a sort. I cannot seem to neutralize this determination or save the changes at run time.

The popup happens before the form unload event and the form close event so that did not work either.

DoCmd.SetWarnings False
Me.OrderBy = "[StockNum] ASC": Me.OrderByOn = True: lblSortOrder.Caption = "Form sort by [StockNum]."
DoCmd.Close acForm, Me.Name, acSaveYes
DoCmd.SetWarnings True

Select allOpen in new window

in the Unload event, the form is already closing ... perhaps

DoCmd.SetWarnings False

Select allOpen in new window

And then

DoCmd.SetWarnings True

Select allOpen in new window

in the form Close event?

~~~

if that doesn't work:

have an option on the main part of the form for the sort order and evaluate it on the form Load event.

Thank you for your input.   I  believe this is a bug.  See   https://goo.gl/2qp4Bd

From this site though,  I found a workaround.

For all  Navigation Tabs      in the Enter Event                        DoCmd.SetWarnings False
For all forms ...                     in the Form_Load event             DoCmd.SetWarnings True

It's not my preferred solution, but it does work.

you're welcome ~ happy to help

glad you got something that works .... be sure to also put DoCmd.SetWarnings True in the Close event of your navigation form! ... and in the Open event of any forms or reports you popup or open

Personally, I don't usually use the Navigation control much because it does not work with complex forms, so I still use the tab control and do my own loading and unloading ... but the navigation control does handle that automatically so better use of resources.

warm regards,
crystal

~ have an awesome day ~

I will consider what you said about not using the Navigation Control.  It does make things more simple,  but it requires the project to be more simple as well.  I am  committed on this project, but I will explore in the future.

Thank you for your help.  Have a great day.

you're welcome ~ happy to help

warm regards,
crystal

~ have an awesome day ~