A
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?
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?