You may want to try changing your statement to something like:

strSQL = "SELECT * FROM mytable WHERE code = " & chr(34) & txtcode.text & chr(34)

That method above always seems to work for me.

Also, what version of ADO are you using? You may have to install MDAC on your other "test" computer. It's amazing the errors you do NOT get on the developmental computer and get on test computers.

Good luck :-)

Eric