Home

Access Help with Filter by Form

%3CLINGO-SUB%20id%3D%22lingo-sub-918576%22%20slang%3D%22en-US%22%3EAccess%20Help%20with%20Filter%20by%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-918576%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20discover%20how%20to%20invoke%20a%20%22Filter%20by%20Form%22%20command%20in%20a%20macro%20or%20via%20vba.%20What%20I%20want%20to%20do%20is%20add%20a%20button%20to%20a%20form%20that%20will%20invoke%20the%20Filter%20by%20Form%20function%2C%20without%20clicking%20the%20command%20in%20the%20ribbon...is%20this%20possible%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20hints%20gratefully%20accepted...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-918576%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
AccessAdam
Occasional Visitor

Hi there,

 

I am trying to discover how to invoke a "Filter by Form" command in a macro or via vba. What I want to do is add a button to a form that will invoke the Filter by Form function, without clicking the command in the ribbon...is this possible? 

 

Any hints gratefully accepted...

1 Reply

@AccessAdam In the click event of a button

Me.Filter = "SomeField = 'SomeValue'"

Me.FilterOn=True

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies