OpenRecordset error

[Glenn Suggs]

Can someone help with this problem? I'm trying to open a recordset in DAO.
Here is the statement and the error message. (The recordset is a query)

Set rs = CurrentDb.OpenRecordset("qryInspectionsCompletedManholes",
dbOpenDynaset)

Error #3061 was generated by DAO.Database.
Too few parameters. Expected 2 at line 100.

Thanks in advance.

 

[Alex Dybenko]

Hi,
perhaps you have references to a form in your query, which should be
replaced with values, if you post your query SQL - we can give more specific
answer

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[ruralguy via AccessMonster.com]

Does the query open directly? Where is the Dim statement for rs?
Dim rs As DAO.Recordset