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?
BONUS FOR MEMBERS:
Silver Members and up get access to an Extended Cut of this video. I 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!
MEMBERS VIDEO:
[ Ссылка ]
BECOME A MEMBER:
[ Ссылка ]
LEARN MORE:
[ Ссылка ]
LINKS:
Query Criteria: [ Ссылка ]
Filter On Load: [ Ссылка ]
SQL Seminar: [ Ссылка ]
Recordsets in Developer 16: [ Ссылка ]
Double Double Quotes: [ Ссылка ]
Search Seminar: [ Ссылка ]
LEARN MORE:
FREE Access Beginner Level 1: [ Ссылка ]
$1 Access Level 2: [ Ссылка ]
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: [ Ссылка ]
Blank Template: [ Ссылка ]
Contact Management: [ Ссылка ]
Order Entry & Invoicing: [ Ссылка ]
More Access Templates: [ Ссылка ]
ADDITIONAL RESOURCES:
Get on my Mailing List: [ Ссылка ]
TechHelp: [ Ссылка ]
Consulting Help: [ Ссылка ]
Twitter: [ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
Email Me: amicron@gmail.com
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, search, filter, filter by form, filter customers, find, criteria, replace, substitute, save to table, update, runsql
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
![](https://i.ytimg.com/vi/9Pt3NbL8TZg/maxresdefault.jpg)