Access Parameter Query as Recordset

[VoodooRageII]

I have some reports that step through a recordset (Table) but would like to narrow the recordset down by using a query as the recordset instead. My problem is that when I use a parameter query that gets the date range from a form it bombs out creating the recordset. I dont think that when it creates the recordset the parameters have a chance to execute. Currently the recordset consists of the table but once a history of use is built in the table performance is going to take a hit which is why I would like to use a query to narrow down the recordset used.

Thanks!

 

[FEDSEC]

You need to set your Recordset type as Dynaset , if not Access default type is Table type with wont work with a query

 

[VoodooRageII]

I tried the Dynaset but still got the "Too Few Parameters, 2 Expected"?

 

[cmmrfrds]

You should show your query and how you supply the parameters to the query. Is the query the datasource for a Form?