A Better Solution Than the On Filter Event in Forms

In this Microsoft Access tutorial, I'm going to teach you about the On Filter event, why I think it's useless and don't use it. I'm going to show you two better alternatives. We're going to synchronize the filter in two side-by-side continuous forms.

Elijah from Bolingbrook, Illinois (a Platinum Member) asks: I've got two continuous forms that I have open side by side. On the left, I have my customers, and on the right, I've got my sales reps. Sales reps are assigned by state. Now, if I filter the customer list on the left by state, I would like it to only show the sales reps who are assigned to that state. I'm trying to use the "On Filter" event, but it doesn't seem to be doing anything. What am I doing wrong, and how can I get this to work?

Members

There is no extended cut, but here's the database file:

•  Database Download - Gold Members

Prerequisites

• Intro to VBA
• Filter Records
• After Update
• Aggregate Query
• Variables
• Replace Function

Links

• Filter Report
• Is Form Loaded
• Microsoft On Filter
• Microsoft Apply Filter

Recommended Courses

• Access Developer Courses
• Access Search Template

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, On Filter event, Form filter event, Form ApplyFilter event, alternative to On Filter event, side-by-side continuous forms, syncing filters, forms synchronization, filter event usage, filter data, form filtering, continuous forms filtering, form design best practices.