Working in MS Access 2010, I find that the filters that users set to work with data in a form that is open in Form View are saved with the form. When the form is subsequently opened (by any user), the data is filtered per the filter set previously. This is very disruptive as the filter was not part of the form's design, and not all the data that should be displayed is displayed.
How can I prevent this from happening?
Research has turned up an article indicting a form property such as "Allow Design Changes" that can be set to allow such changes in Design View only, but I haven't been able to find this property on the form property sheet (for firms in Access 2010).