Turn off filter with command button 1

[netrusher]

Can anyone tell me if it is possible to turn off a filter on a form using a command button?
If so could you post the code? I would appreciate any help!

 

[bubba100]

[Forms]![YourForm].FilterOn = False

 

[TheAceMan1]

How are ya netrusher . . .

Have you tried:

[blue]   Me.FilterOn = False[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[netrusher]

Great AceMan! thanks a lot!

How about Filter by Selection with a Command Button?

 

[bubba100]

Take a look at this it might help faq702-777

 

[netrusher]

Thanks Bubba,

What I am trying to accomplish is as follows:

Whatever field the person is in I want them to be able
to hit a command button and filter by selection instead
of right clicking and selecting filter by selection. Hope
that can be done and am anxiously awaiting solution.

I appreciate all help!

 

[netrusher]

Thanks everyone:

I found the following code fron another posting.

Screen.PreviousControl.SetFocus
     DoCmd.RunCommand acCmdFilterBySelection

 

[TheAceMan1]

netrusher . . .

You could automate [blue]FilterBySelection[/blue] by using the fields [blue]On Dbl Click[/blue] event instead of the button! . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886