|
|
|
Build a Multi-Field Search Form
Using the LIKE keyword in Access
In this tutorial you will learn how to build a
multi-field search form for your Microsoft Access database. We will
start with a simple table containing customers.
We will then build an unbound form with text boxes on it
to allow the user to enter in search criteria. Here, for example, you can
see we're looking for customers with a last name of "smith" who are from
"buffalo".
Finally, we will build a query using
Forms!FormName!FieldName notation to read in the search criteria. We will
use the LIKE keyword with wildcard characters so that any search
fields left blank are ignored. This will give us the requested result.
Here is a VIDEO TUTORIAL
that will walk you through this topic in detail. Click on the link
below.
You can learn more about building search forms in my
Search Seminar.
By Richard Rost
Click here to sign up for more FREE tips
|