If you wish to have several records possible (like searching for "smith" in the phone book), and you want to display the results, you need to iterate (loop) through the recordset.
Do while rs.eof=false
cmbCombo1.additem( "" & rs.Fields("TEST_NAME"))
'moves the database to the next...
To Turn off the beep, create a "KeyPress" event for the textbox, and enter this code
if keyascii=13 then
keyascii=0
'do whatever you wanted
end if
by resetting the keyascii (the ascii value of the keypress) you'll eliminate the beep.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.