Sorry, 90% of my work is done in assembly and the other in C++. DAO is the only thing I've ever used with VB

I'm not sure how similar ADODC is to DAO, but this is what I've used in the command buttons click event


Dim Sql as String

Sql = "SELECT * FROM Table WHERE Str = '" & txtInputBox & "'"
Set...