Need Help -- Type MisMatch Error 13

[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.

 

[Tom Wickerath]

Hi TL,

Possibly a reference priority issue, which you can avoid by "disambiguating"
the declaration of rstnew:

ADO and DAO Library References in Access Databases
http://www.accessmvp.com/TWickerath/articles/adodao.htm


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________