Quote:
Originally Posted by Vic01
If I type in a list box (or similar appropriate object) "Jo", the name "Robert Jones" appears in the list box and I click on it and the name "Robert Jones" is retrieved from the excel file and 'appears' in that place where the list box is, along with that doctor's address (which is in the excel file)
|
It's a whole lot more complicated than that. What happens if your database has Dr Robert Jones, Dr Martha Jones, Dr Fred Johns, Dr John Johnson, Dr Ian Johnston and Dr Ann Johnstone? How is typing
"Jo" going to get you the required output? Even typing
"Jones" or
"Johns" won't give you a single match and presumably you don't want your code to choose one at random. The best you'll do in many cases is to obtain a list of possibilities from which you must choose. I ought to know - I worked with electoral rolls for 25 years...