Unanswered: type mismatch erroer from a query from VB
A runtime error 13, "Type Mismatch" is generated from the recordset creation query. What is causing this error and what needs correcting.
Dim rs As Recordset ' Open Data Table
strSQL = "SELECT TAG_NO From [SCR - DATABASE] WHERE [I/O]=True AND INSTR=True"
Debug.Print strSQL 'Checks syntax of SQL Statement
Set rs = dbCHSP.OpenRecordset(strSQL)'Create a recordset