I have developed a Microsoft Access 2010 database that uses navigation subforms nested a couple layers deep. When the user clicks on navigation tabs to change the form displayed in the subform (sourceobject), a dialog box appears asking the user:
"Do you want to save changes to the design of the form 'form name'?"
This is obviously unacceptable in a deployed database. How can I get rid of this behavior, so that users can use the navigation tabs without being asked if they want to change design of the form?
I have already programmed logic allowing users to decide whether or not to save data changes. I do not want the user to be prompted about design changes.
try to set AllowDesignChanges property to "Design View Only"