Microsoft access 2007 filter

Question

Is there a setting in Microsoft Access 2007 to disable toggle filter button permanently? Everytime I load a form the filter button is toggled automatically..

Answer 1

If you open your form in design mode and open up the properties for the form, on the 'data' tab, you will see an option called 'Allow filters'. If you select 'NO' then this toggle filter button will be disabled when you load the form.