Use Find & Replace and Filter By Form to Search on Multiple Fields in your Microsoft Access Database

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?

Silver Members and up get access to an Extended Cut of this video. 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.

MEMBERS VIDEO:

BECOME A MEMBER:

LEARN MORE:

LINKS:

COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

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

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[panshulagunasekaran]

good evening sir, i am working on a database where i have the customer's name and their phone number in a table. I am trying to do a thing where i could search for a customer just by using their phone number or their name. no matter where i am (in the main menu of the database/ looking at any form) i want to be able to search for the customer across the whole database...is it possible?...i hope you could understand what i'm trying to say here..😅

[ranjishiyama]

I want my search button look on 9 columns entered on the search box. What's the best approach with such number of columns?

[anupmukherjee]

Sir, I want to search cheque no in a form by search bottom. Which is a text fild.