Search as you Type combobox with database

See more:

VB6

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 tutorial - 1
Source code at SourceCode 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 because the code is very long