OpenRecordset error '3061'

[jl2000]

Hi,
I have a simple Access 2000 database and DAO 3.6 Library and I need get a record count from a existing query. But at run time I got an error:
OpenRecordset error '3061' Too few parameters. Expected 2.
Here is the code:

Dim db As DAO.Database
Dim rs As DAO.Recordset

Set db = DBEngine.Workspaces(0).Databases(0)

Set rs = db.OpenRecordset("My_Query_Name",dbOpenDynaset)

rs.MoveFirst
n = rs!Field_ToBeGet
rs.Close
Set db = Nothing

Even I fillup all optional field on openrecordset, it comes the same error message. I do need help. Thanks!

 

[Rolliee]

Why not n = rs.recordcount

Rollie E

 

[Thanks]

Thanks Rolliee!
May you tell me more about the error message, that whould be very help.