|
||||||
|
Filter Records By Richard Rost ![]() ![]() Filter Form Data to Find Records Quickly & Easily In today's video, I'm going to teach you how to use a Filter in Microsoft Access to limit the data displayed in your forms, and search for just the information you want quickly and easily. Lewis from Cheektowaga, New York (a Gold Member) asks: I've got a few thousand customers in my customer table. I need to be able to quickly and easily filter this list and I don't want to make a bunch of queries because my needs change from moment to moment. One time it might be customers from NY with $1000 credit limits. Another time it might be anyone from the 716 area code with the last name Smith. What do you recommend? MembersI will show you how to create a combo box on your customer list form to save all of your favorite filters. Then we will learn how to add criteria to that with the Replace function and a little variable substitution. Then we will learn how to set up the filter in the form itself and SAVE it to the table the combo box is based on, updating the box. Really cool stuff in this lesson!
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
|
Learn MoreFREE Access Beginner Level 1 Free TemplatesTechHelp Free Templates |
ResourcesMailing List - Get emails when new videos released Questions?Please feel free to post your questions or comments below or post them in the Forums. |
Age | Subject | From | |
3 months | Right Click Filter on a form | Frederick Fisher | |
18 months | Apply Multiple Filters | Richard Pitassy | |
2 years | Cant Filter by CRITERIA | Brian Hartwig | |
2 years | Cannot access extended cut | Rajashree Natarajan | |
2 years | Extended Filter records video | Lwm Harmsma | |
| |||
Keywords: TechHelp Access search, filter, filter by form, filter customers, find, criteria, replace, substitute, save to table, update, runsql, me.filter, me.filteron PermaLink Filter Records in Microsoft Access |