By Richard Rost 2 years ago
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 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.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
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
Subscribe to Multi-Field Find
Get notifications when this page is updated