Need Help -- Type MisMatch Error 13

T

TL

I am not very good at VBA but have been tasked with converting a 2000 mdb to
a 2007 accdb. I have gotten most of the database converted but found an issue
today when importing a text file then rerunning some queries on the data. The
line of code that is causing the issue is:
Set rstNew = dbsMU.OpenRecordset("qryAppendNewCombinationsCount", 2)

The data gets imported into a table then join on another table. The fields
that are being joined are both formatted as text put contain numbers.

Any help would be greatly appreciated.
 
Top