Unanswered: data type mismach while using openrecordset method
I keep getting this "data mismatch in criteria expression" error.
The code is simple and I have not been able to figure out the error.
If someone could help me out, it would be great.
TestQry = "SELECT [WC#] FROM [wc_Lookup_tbl] WHERE [WC#]=" & WC & ";"
Set qdf1 = db1.CreateQueryDef("", TestQry)
Set Val1 = qdf1.OpenRecordset()