Microsoft Access Search: Find a Record on My Form Based on the Value I Selected in my Combo Box

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:
   • Find Record Combo Box EXTENDED CUT ME...  

BECOME A MEMBER:
YouTube:    / @599cd  
or My Site: https://599cd.com/THMember

LEARN MORE:
https://599cd.com/FindRecordCombo

RECOMMENDED COURSE:
Access Beginner 8: https://599cd.com/ACB8

LINKS:
Search Form 2.0: https://599cd.com/SearchForm
Blank Template: https://599cd.com/Blank
Query Criteria: https://599cd.com/Criteria
What is Null?: https://599cd.com/Null
Aggregate Query: https://599cd.com/Agg
Filter Records: https://599cd.com/Filter
Intro to VBA: https://599cd.com/IntroVBA
Double Double Quotes: https://599cd.com/DoubleDouble
Relational Combo: https://599cd.com/RelationalCombo
If Then: https://599cd.com/IfThen
Access SQL: https://599cd.com/SQLwithAccess

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
$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:   / 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, 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.