set a dao recordset object to a query with parameters

[LaDeana1]

I have a query which uses a formfields as it's parameter. I can use code to open this query docmd.openquery however, when I try to set it as a dao recordset, I get "Too Few Parameters expected Expected 2."

I am using txtfromdate and txttodate from a form and the query runs great even in code. But DAO doensn't like it. Any Suggestions? Am I hitting a limitation?

 

[PHV]

Have a look here: thread701-938203

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886