DoCmd.FilterOn=False

[Denver]

I have a Form with a subform on it i have a cmdRemove Filter
with this code

DoCmd.FilterOn=False

but when i make filter on my subform and click cmdRemove Filter it does
function.
What do i miss on my codes?

Hope anyone is kind to help me on how to write my code to accomplish this
work.

thanks

 

[Allen Browne]

FilterOn is a property of the form.
It is not a method of DoCmd.

Try something like this:
Me.FilterOn = False
or:
Forms!Form1.FilterOn = False
or, if you are using a subform:
Forms!Form1!Sub1.Form.FilterOn = False

 

[Denver]

Thank Allen Browne.

it really works. thanks
Denver