How can I display error message for info not found in query parame

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that allows a user to enter a name and the info connected to
that name is shown. How do I give a message stating that the name is not in
the database and allow the user to search again? And how do you search the
database for names variations or spelling close to the name the user inputs?

Thanks
 
You need to use a form to achieve the interface you describe.

In a form, you could use an unbound combo box with all the available names.
When the user selects one, you jump to that record. The question does of
choosing a bad name does not arise. Details:
Using a Combo Box to Find Records
at
http://allenbrowne.com/ser-03.html

If you prefer, you could use a text box, and use its AfterUpdate event
procedure to set the Filter of the form, so that it contains only records
that match the name.

The question about "close spellings" is different again. The Soundex
alogrithm is the standard way to do this.
 
Back
Top