type mismatch?

got a type mismatch error on:

Set RS = DB.OpenRecordset(ReportSQL)

ReportSQL is a SQL string
any ideas?

Set RS = DB.Execute(reportSQL)

assuming that DM = adodb.connection, and that you have set that connection up properly.

what? so i have to go to "References" under "Project" and move ADO 's priority above the DAO?

Your using DAO? Ahh okay then. I can't answer your question then. It was intended for ADO but you didn't specifiy.