multicolumn listbox search

[amit_m04]

Hi,

I want to create a search option

I have 3 text box with "name", "address", "phone number" on a form.

what i want is when i start typing into the "name" textbox there should be a multicolum listbox with name and phone number,
and as i type into the textbox the name should be searched into the listbox and highlited.
when i select the name from the listbox the remaning textbox (address & phone number) should get the data accordingl from the database.

if the name that i type into name textbox is not available in the listbox then i should get other two text box so that i can type the address and phone number and when i click save it (name, address, phone number) should be saved into the database.

please help me on this, it is a part of my project.

Thanks