Recent content by gdfarrell

Here is some more information ..... I found that simply using forms!frmYourForm.recordsource = "My Query" Docmd.Requery Removed the filter from the form and sped things up as well.

Wazz, You headed me in the right direction by putting... Me.FilterOn = False forms!frmYourForm.recordsource = "My Query" Docmd.Requery This basically emulates the Remove Filter icon.Thanks for your help on this.

Hi WAZZ, Thanks for the input but the me.Requery behaved the same as the Docmd.Requery. I still need to click the icon to effectively remove the filter and allow the query to behave normally.

I am using the Requery command which does requery the database not the Refresh method. I just called the button a refresh button for the users. Would you know why the Remove Filter Icon on the Filter sort menu does not behave like the DoCmd.RunCommand acCmdRemoveFilterSort or the...

I have a form that has a requery button and a separate form filter button. The form has two unbound fields that are referenced in the forms Query criteria. When I first enter the form without applying filters, the requery button accurately refreshes the form based on the values entered into the...