I am trying to use the InStr variable to search through an ADO recordset.
Problem: I get a type mismatch error within my code when trying to run the ADO in a recordset. Another thing, when I just type in a string, and use the InStr variable, it works.
I'm thinking, maybe you can't use the InStr variable when searching recordsets.
Any help would be appreciated.
Problem: I get a type mismatch error within my code when trying to run the ADO in a recordset. Another thing, when I just type in a string, and use the InStr variable, it works.
I'm thinking, maybe you can't use the InStr variable when searching recordsets.
Any help would be appreciated.