How to Use Form Controls as Query Criteria in Microsoft Access - Search Form

In this video, we will walk through how to build a simple search form in Microsoft Access using form controls as query criteria. I will show you how to set up text boxes for first and last name searches (including partial matches), use a combo box for selecting state, and add a check box to filter by active or inactive customers, all without requiring programming. We will connect these controls to a query, demonstrate how to base forms and reports on the search results, and briefly discuss how a small amount of VBA can further enhance your search capabilities. Sabrina from Columbus, Ohio (a Silver Member) asks I need to be able to look up customers by first and last name (often partials), filter by what state they're from, and usually I only want to see active customers, but sometimes I need to look for inactive ones instead. Is there a simple way to build a search form that lets me do all of that without getting into a lot of complicated code? Oh, and it has to be easy too, since a lot of my company's users aren't very computer adept. Silver Members & up get access to an Extended Cut of this video. In the extended cut, we will build advanced search functionality using VBA and SQL, remove the need for a saved query, add a visible SQL editor that updates in real time, allow user-selectable AND/OR search conditions, use a triple-state checkbox for filtering active, inactive, or both customer statuses, enable typing custom SQL, saving custom search queries, and modify the combo box to dynamically display unique state values from the table. I will show you how to implement all of these features to create a more powerful and flexible search form. MEMBERS-ONLY EXTENDED CUT VIDEO:    • Form Controls EXTENDED CUT MEMBERS ONLY Ad...   BECOME A MEMBER: YouTube:    / @599cd   or My Site: https://599cd.com/THMember LEARN MORE: Form Controls: https://599cd.com/FormControls PREREQUISITES: Access Beginner 1: https://599cd.com/ACB1 Blank Template: https://599cd.com/Blank Command Buttons: https://599cd.com/CommandButtons Value From a Form: https://599cd.com/FormName Wildcard Search & Like: https://599cd.com/Like Value List Combo: https://599cd.com/ComboValueList LINKS: Access Search Seminar: https://599cd.com/SearchS RECOMMENDED COURSES: Access Developer Courses: https://599cd.com/Developer 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 DIAMOND SPONSORS: More info on our Sponsors: https://599cd.com/DiamondSponsors ADDITIONAL RESOURCES: FREE Access Beginner Level 1: https://599cd.com/Free1 How to Use Access in 30 Minutes: https://599cd.com/30Minutes $1 Access Level 2: https://599cd.com/1Dollar Donate to my Tip Jar: https://599cd.com/TipJar Merch Store! Get your swag here: https://599cd.com/Merch 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: TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, form controls as query criteria, search form, text box query, combo box query, check box criteria, wildcard search, Like operator, value list combo box, unbound form, forms!mainmenuf!lastname search, and/or condition, customer search query, active inactive filter, state search QUESTIONS: Please feel free to post your questions or comments below. Thanks. Live long, and prosper.