I am not very familiar with recordsets but not too bad either!
Set rs = db.OpenRecordset("select distinct RepArea from qryExportPrepare01")
This line of code gives Error 3061 Too Few parameters.
It works when I base the select on a table but fails when based on a query.
I need to base my recordset on the query above (NOT a table)
How do I do this?