Microsoft Access Multi-Field Search Form 2.0 New and Improved Features!

In this video, I'm going to teach you how to make a multi-field search form so that you can find records based on multiple criteria such as a partial first name, last name, state, and so on. We'll also see how to search for numeric values, including dates, and yes/no fields. This video is a followup to one of my most popular YouTube videos on making a multi-field search form. The original was released in 2011 and received over 580,000 views and more than 500 comments and questions over the past 10 years. So in this video, we're going to build the Search Form bigger and better, add some new features, and answer some of the questions people posted about the original. Silver Members and up get access to an Extended Cut of this video. Members will learn how to create a much more powerful version of this search form without using a query. We will use VBA to dynamically write the SQL statement that feeds data to the form on the fly. We will also resolve the problem of the blank values, and see how to incorporate a sort order into our form. MEMBERS VIDEO:    • Access Search Form 2.0 EXTENDED CUT MEMBER...   BECOME A MEMBER: YouTube:    / @599cd   or My Site: https://599cd.com/THMember LEARN MORE: https://599cd.com/SearchForm2 LINKS: Original Search Form: https://599cd.com/MultiFieldSearch Blank Database Template: https://599cd.com/Blank Query Criteria: https://599cd.com/Criteria Value From Open Form: https://599cd.com/FormName Wildcard Search: https://599cd.com/Wildcard Concatenation: https://599cd.com/Concat Between: https://599cd.com/Between Intro to VBA: https://599cd.com/VBA Search Seminar: https://599cd.com/SearchSeminar SQL Seminar: https://599cd.com/SQLSeminar IIF Function: https://599cd.com/IIF AfterUpdate: https://599cd.com/AfterUpdate Evil Access Stuff: https://599cd.com/Evil Double Double Quotes: https://599cd.com/Double COURSES: FREE Access Beginner Level 1: https://599cd.com/Free1 $1 Access Level 2: https://599cd.com/1Dollar 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: 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: microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, search form, requery, dynamic sql, find records, locate specific records, query criteria, search box, search criteria, go to specific record, search form multiple fields, multi field search, filter multiple fields, multiple criteria, multi field search form, advanced search form, multiple keyword search, wildcard, vba, sql, me.requery QUESTIONS: Please feel free to post your questions or comments below. Thanks.