A Better Solution Than the On Filter Event in Microsoft Access Forms
4.6 هزار بار بازدید -
9 ماه پیش
-
In this Microsoft Access tutorial,
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?
BECOME A MEMBER:
YouTube: @599cd
or My Site: https://599cd.com/THMember
LEARN MORE:
On Filter: https://599cd.com/OnFilter
PREREQUISITES:
Intro to VBA: https://599cd.com/VBA
Filter Records: https://599cd.com/Filter
After Update: https://599cd.com/AU
Aggregate Query: https://599cd.com/Agg
Variables: https://599cd.com/Variables
Replace Function: https://599cd.com/Replace
LINKS:
Filter Report: https://599cd.com/FilterReport
Is Form Loaded: https://599cd.com/IsLoaded
Microsoft On Filter: https://599cd.com/MSFT-OnFilter
Microsoft Apply Filter: https://599cd.com/MSFT-ApplyFilter
RECOMMENDED COURSES:
Access Developer Courses: https://599cd.com/Developer
Access Search Template: https://599cd.com/SearchTemplate
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
How to Use Access in 30 Minutes: https://599cd.com/30Minutes
$1 Access Level 2: https://599cd.com/1Dollar
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter: Twitter: LearningAccess
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...
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.
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
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?
BECOME A MEMBER:
YouTube: @599cd
or My Site: https://599cd.com/THMember
LEARN MORE:
On Filter: https://599cd.com/OnFilter
PREREQUISITES:
Intro to VBA: https://599cd.com/VBA
Filter Records: https://599cd.com/Filter
After Update: https://599cd.com/AU
Aggregate Query: https://599cd.com/Agg
Variables: https://599cd.com/Variables
Replace Function: https://599cd.com/Replace
LINKS:
Filter Report: https://599cd.com/FilterReport
Is Form Loaded: https://599cd.com/IsLoaded
Microsoft On Filter: https://599cd.com/MSFT-OnFilter
Microsoft Apply Filter: https://599cd.com/MSFT-ApplyFilter
RECOMMENDED COURSES:
Access Developer Courses: https://599cd.com/Developer
Access Search Template: https://599cd.com/SearchTemplate
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
How to Use Access in 30 Minutes: https://599cd.com/30Minutes
$1 Access Level 2: https://599cd.com/1Dollar
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter: Twitter: LearningAccess
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...
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.
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
9 ماه پیش
در تاریخ 1402/07/17 منتشر شده
است.
4,601
بـار بازدید شده