Zero-Code Multi-Field Search in Microsoft Access

In this Microsoft Access tutorial, I'm going to teach you how to make a simple search form where you can search multiple fields. We'll use AND and OR conditions so you can search for either records that have all of the criteria or any of the criteria, and we'll do it with zero programming, so even beginners will be able to follow this one.

Grant from Decatur, Georgia (a Platinum Member) asks: I've watched several of your videos on building a search form. They're all very helpful, but most are a little bit over my head. I'm not a VBA programmer, and I really don't want to learn how to program. Is there an easy, simple way you can show us how to just do a search form that brings up a query with my results? I need to be able to search on first name, last name, and email address, and sometimes it can be one, two, or all three of those that I need to look for. I really want a search form like you show because my users are clueless and I don't want them to deal with queries and parameter prompts and such. Thanks!

Prerequisites

• Access Beginner 1
• Access in 30 Minutes
• Value From a Form
• Wildcard Search & Like
• And Or Not
• Concatenation

Links

• Blank Template

Up Next

• Easy Search Form, Part 2

Recommended Courses

• Access Beginner Courses

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

TechHelp Access, simple multi-field search form, search multiple fields, Microsoft Access, no VBA, query results, wildcard searches, LIKE keyword, customer form, contacts management, no programming search