filter

  • Thread starter Thread starter klp via AccessMonster.com
  • Start date Start date
K

klp via AccessMonster.com

I have a form that displays prospective customer information. Sometimes we
will get inquiries from customers that are already in the system. We have 2
separate tables one for Customers and one for Prospective Customers.
Currently, when a user goes to lookup a prospective customer it will show, in
a subform, if there is a customer already by the same name. However, they may
not always type it the same as in the customer table. What I need is when
they are either looking up a prospective customer or entering in a new
prospective customer for a list of customers with similar but not exact
spelling. My subform currently, contains a list box for it to show the
customers with exact spelling. Any ideas.

Thanks in advance

Kim P
 
Hi,
In the book 'Building Microsoft Access Applications' by John L Viescas, you
will find a database which uses Soundex to pop up a list of similar sounding
names. The book comes with sample databases. It will show exactly how to do
what you want. I have used this book and can highly recommend it.

Jeanette Cunningham
 
Ah - I have this book as well. I will check out the samples! Thank you!

Jeanette said:
Hi,
In the book 'Building Microsoft Access Applications' by John L Viescas, you
will find a database which uses Soundex to pop up a list of similar sounding
names. The book comes with sample databases. It will show exactly how to do
what you want. I have used this book and can highly recommend it.

Jeanette Cunningham
I have a form that displays prospective customer information. Sometimes we
will get inquiries from customers that are already in the system. We have
Click to expand...
[quoted text clipped - 13 lines]
Kim P
Click to expand...
Click to expand...
 
Back
Top