Undo / Remove Filter Sort on a Form in Access 2007

[ericpsu32]

Good Afternoon,

I am having difficulty finding how to remove the filter sort from a form on Access 2007. I do not have the product installed on my machine which makes it difficult for me to just play around to solve the problem. One of our applications has errors on the subtotals for the form. In my research, it was suggested that I remove the filter/sort on the form. I was able to right click on the form and do this on my Access Project '03, but the users of '07 in our office don't seem to have this option in their pop up menu on the form.

Can anyone tell me how to remove the filter/sort from a form on Access Project 2007 similarily to how it is done in 2003?

Thanks in advance for your assistance!

 

[hermanlaksko]

YrFrm.Filter=""
On a report

YrRep.FilterOn=false
and / or YrRep.ServerFilter="" / YrRep.Filter="" (MDB)

Should do the trick.

Herman
Say no to macros