Dynamic Search from Database

I have a form to search a database for a specific clients details.
I enter their name and the form returns their account number.

If the entry is does not have the correct spelling obviously there will be no file found.

How can I get the form to do a partial name search or even dynamically autocomplete from a list of possible entries collated from the database itself?

Thank you and welcome back by the way, totally missed you while you were gone.

Hi U Can Drive,

You can use the AutoCompleter to do an Ajax query back to a form event on the server and add custom code in the event to use any MySQL you like to return results: e.g. LIKE '%xxx%' will pick up any entry with xxx in it.

Bob