Search as you type combobox with database

[dario_ds]

1) I am using the code of Search as you type combobox.The script works fine when records are selected from the combobox,but when I need to enter new I cannot enter.Especially If a name say Ramesha has already been entered in the database and I need to enter a name Ramesh, I am unable to do so.Please help me modify the code.I am using it in registration of new names where the combobox is used to help in registering new name by helping with common names
Tutorial at http://www.vb6.us/tutorials/visual-b...o-box-tutorial
Source code at http://www.vb6.us/files/VBPrograms/C...hAsYouType.zip
2)I am querying a field which is Yes/No.I want to add data when the answer is NO i.e 0. What code is more suitable


If adodc1.Recordset.("Status") = 0 then or
If adodc1.Recordset.("Status") <> -1 then
I am sorry but i did not know whether I should have pasted the code or not after giving the links