In this Microsoft Access tutorial, I will show you how to find a record based on the value you select in a combo box.
Erin from Springfield, Missouri (a Platinum Member) asks: I love your Search Form 2.0 video. I have a great search form that works well because of you. Thank you. I'm trying to simplify it, however. Is there any way that we can just pick from a list of what's already in that field instead of having to type it in? For example, can I pick from a list of last names to show customers with that last name?
Silver Members and up get access to an Extended Cut of this video. Members will learn how to use multiple filter combo boxes together on the same form and either an AND or and OR condition. We'll also make a button to clear the filters.
MEMBERS VIDEO:
[ Ссылка ]
BECOME A MEMBER:
YouTube: [ Ссылка ]
or My Site: [ Ссылка ]
LEARN MORE:
[ Ссылка ]
RECOMMENDED COURSE:
Access Beginner 8: [ Ссылка ]
LINKS:
Search Form 2.0: [ Ссылка ]
Blank Template: [ Ссылка ]
Query Criteria: [ Ссылка ]
What is Null?: [ Ссылка ]
Aggregate Query: [ Ссылка ]
Filter Records: [ Ссылка ]
Intro to VBA: [ Ссылка ]
Double Double Quotes: [ Ссылка ]
Relational Combo: [ Ссылка ]
If Then: [ Ссылка ]
Access SQL: [ Ссылка ]
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: [ Ссылка ]
Blank Template: [ Ссылка ]
Contact Management: [ Ссылка ]
Order Entry & Invoicing: [ Ссылка ]
More Access Templates: [ Ссылка ]
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: [ Ссылка ]
$1 Access Level 2: [ Ссылка ]
Donate to my Tip Jar: [ Ссылка ]
Get on my Mailing List: [ Ссылка ]
Contact Me: [ Ссылка ]
TechHelp: [ Ссылка ]
Consulting Help: [ Ссылка ]
Twitter: [ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
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, search, find, combo box, value, filter, filteron, group by, having, tempvars, function event handler, and/or, clear button, Move to specific record from Combo Box selection, How do I find record in Access form, How do I bring up a record based on a combobox
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
![](https://i.ytimg.com/vi/qQYOwYHU5jw/mqdefault.jpg)