Find Record Combo Box in Microsoft Access

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?

Members

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.

•  Extended Cut Video - Silver
•  Database Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Recommended Course

• Access Beginner 8: https://599cd.com/ACB8

Notes

• If you don't see the 3rd option to find a value when running the wizard, that's because your form's Record Source is not a table. If your form is based on a query, you don't get this option. Watch the video at time index 3:08 for details.

Links

• Combo Box: https://599cd.com/Combo
• 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

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

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