Unexpected prompt to save design from Form View

[williamlove]

This question is specifically about nuances of the Access 2010 Navigation Menu. That is important. I asked this question and got all kinds of answers but they overlooked that crucial aspect of my question.

When I sort or filter records in a form that was opened (in Form View, not Design View) by clicking on the link in the Navigation Form, I get the following Access prompt:

Microsoft Access
/!\ Do you want to save changes to the design of form ‘HydroTreater’? Yes, No, Cancel

If I just open the form the “normal” way, e.g. by double clicking or right clicking and chosing Form View, I cannot reproduce the problem. I can sort and filter but do not get asked to save design changes when I change forms.

I want to continue using the Navigation form, but I can’t if I don’t solve this. Thanks.

 

[vbaInet]

A very strange behaviour. Have you tried creating a new db to see if it repeats itself? Does it happen on any form or report you open in that db?

 

[williamlove]

Yes it happens in others. Yes, any form filtered causes the problem (if opened using naviation, otherwise no problem).

I searched and found some other people had this problem. Long story short it appears to be a bug. I have decided to not use this feature until they fix it.

I'm disappointed that such a blatant and ugly problem was either overlooked or disregarded because it mars the very appealing new 2010 Navigation menu and in fact makes it unusable for me.

 

[vbaInet]

Care to share the link where you got this insight?

 

[David S]

Hi vbaInet
I cannot see a reply to your (above) request to share a link? I have found a link but as I have not yet posted more than 10 times the system disallows my sharing it with you. But I hope the following broken link is sufficient for you to recreate fully:
– social.mdsn.microsoft.com
- /Forums/sv-SE/accessdev/thread/817e24aa-9ff2-4f13-bf1a-bbd073590bac
Perhaps it is the same source ‘williamlove’ has quoted?
It appears this problem is un-resolved!
I myself first noticed this problem today when testing my nearly completed Navigation form. In my particular case, I was using a filter on a datasheet subform within a Navigation form and kept encountering a prompt to save the form, although I had not made any changes? On testing the same form ‘outside’ of the Navigatio form I encountered no such prompt to save.
But it seems this is a larger issue involving use of the Navigation format! Any comments you may have would be very useful to me as I have worked for weeks on various forms used in a single Navigation form and this new (to me) problem is a bombshell. Thanks in anticipation.

 

[vbaInet]

Thanks for sharing David S. It would come in handy for anyone else reading this thread.

I don't have Access 2010 installed so I can't recreate the problem in order to come up with a solution.

 

[jtma67]

Not an update.. but I also have experienced this same problem with the unexpected prompt to save changes to a form. I'm very new to Access 2010 and thought it was something that I was doing wrong :banghead:. If anyone has any work around for this issue when using a navigation form, it would be greatly appreciated.

 

[boblarson]

Make sure if you use any DoCmd.Close command to close a form you should really do it like this:

DoCmd.Close acForm, Me.Name, acSaveNo

(you can leave the Me.Name just as is which makes it easy to copy and use in other places)

The acSaveNo tells it to discard any design changes that may have occurred. The default is acSavePrompt so if you don't specify acSaveNo it will ask you, or the user. And you don't want it to save those.