Query/Form...User Searches

A

Arkie

I have a database in which users can search for data through a form. The form
is tied to a query/table/macro. For example, a common search using queries
would be by the "Site Name". However, I do not know how to set up the query
such that the user does not have to know the complete "Site Name". The way I
have the query set up is that the user must enter the full site name. The
Site Names are unique to the site but may contain some similar words such as
mine, site, scatter, etc. How can I set it up so that the user can serach by
site name, and can enter only partial search info? Thanks for any help you
can give.
 
M

Mark

On your form, add a combo box using the combo box wizard. Choose the option
to "Find a record based on a value" (or some similar wording) and go through
all the steps. You will then have a combo box listing all of your site
names and when the user starts typing a name, it will auto-complete the
first matching record; type more and it will narrow the results. Once the
user selects the site they want, your form will jump right to that record.
 
A

Arkie

Thanks so much for the reply. I tried it & it's a start. However, it only
works if you know the beginning of the site name, not just a random word
within the site name. Any other thoughts?
 
Top