Multi-Field Find & Replace, Filter By Form, Me.Filter

In this video, I will show you how to find data across multiple fields on your form using both Find & Replace and the Filter by Form tool. This will allow you to search for any values across those fields.

David from Salt Lake City, Utah (a Silver Member) asks: I have multiple fields in my form (Part1, Part2, etc. up to Part10) and I want to be able to search across all of them. How can I do this in Access?

Members

Members will learn how to use VBA and a single text box to perform a similar search across multiple fields with the Filter and FilterOn commands.

•  Extended Cut Video - Silver
•  Gold Member Template 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!

Links

• Filter: https://599cd.com/Filter
• Wildcard Search: https://599cd.com/Like

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 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

microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, filter, filter by form, Me.Filter, Me.FilterOn, search box, selection, multiple fields