MS Access 2010 - How to prevent accidental changes to Form design by users using forms in Form view?

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

June 17th, 2015 11:28pm

Set the Close Button property of the form to No (this property is listed in the Format tab of the Property Sheet).

Create a command button cmdClose on the form, with the following event procedure in its On Click event:

Private Sub cmdClose_Click()
    DoCmd.Close acForm, Me.Name, acSaveNo
End Sub

Clicking the button will close the form without saving changes to filters etc.

Free Windows Admin Tool Kit Click here and download it now
June 18th, 2015 12:24am

Thank you for your suggestion, Hans.

Unfortunately, the forms in question are all subforms, so there is no active Close button.  They close automatically as the parent form closes.

Thanks again.

June 18th, 2015 12:08pm

Apply my suggestion to the main form. This will prevent the subforms from being saved too.
Free Windows Admin Tool Kit Click here and download it now
June 18th, 2015 2:38pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics