creating a keyword search using macros

[ajwittman]

I have created an Access database that houses information for 2000
properties. In this database, the user can search properties by taxlot
number or street address. I would like them to be able to search the
form (called 'Mainpage') by keyword. For example, the property
located at 170 SOUTH OREGON STREET is also known as the Brunner
Building and the Old Library. Ideally, I would like them to be able to
search "Brunner," "Old," "Library," etc. and the form for
the 170 SOUTH OREGON STREET would appear. So, I have created a field
(called 'Search' that is located on Mainpage) that has a string of
all the words that each individual property could be called.

Others have told me to create a query with criteria and then link it to
the form. Something went awry there... As a self-taught novice, I
cannot seem to understand what is going wrong and what I have to do to
get this to work.

One told me to utilize the 'After Update' Command, but, again,
things did not work out.

Does anyoneknow how might be the easiest way to create this keyword
search?

 

[Allen Browne]

There is an example database you can download in this article:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html

Import it into your database, and copy the combo and text box to your form.
You can then choose which field you want to search from the combo (taxlot,
number, street address, or keyword), and type the value you want to find
into the text box.