filter

[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

 

[Jeanette Cunningham]

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

 

[klp via AccessMonster.com]

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

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

[quoted text clipped - 13 lines]

Kim P