Invoke Filter by Form

[Costefran]

Hello

Can anyone advise if their is applicable code that can either replicate or invoke the filter by form event and then apply the filter as I'd like to action this as on on click event of a command button on my form

The form does not have any subforms if it helps

Many Thanks

Costefran

 

[TheAceMan1]

How are ya Costefran . . .

Have a look at the following form events:
[blue] On Filter[/blue]
[blue] On Apply Filter[/blue]

The [blue]DoCmd Object[/blue] also has the following methods:
[blue] DoCmd.RunCommand acCmdFilterByForm[/blue]
[blue]DoCmd.RunCommand acCmdApplyFilterSort[/blue]
[blue] DoCmd.RunCommand acCmdRemoveFilterSort[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[PHV]

In the Click event procedure of your button you may set the Filter and FilterOn properties of the form.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886