Easy Search Form
By Richard Rost 17 days ago
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!
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
Subscribe to Easy Search Form
Get notifications when this page is updated