Database

[AcornRanch]

I am working and making a database program and would like to know if there is a way to have the program scan the database when letters are typed. Some program as soon as you type and "a" it brings up the first "a" word in the database and as you continue to type it checks again for matches. Does anybody know how to code that?

[razzaj]

well , i dont know all the tips for db but
here is how i would do it for a regular list
we assume for that example that we have a from with a textbox and one list and one db recordset :

here is a pseudo code :


private sub text1_change()
for x = 1 to end ofdb
y = element(x) from db
if mid(y,1,len(text1)) = text1 then list1.additem element(x)
next x
end sub



------------------
- regards -
- razzaj -