Hi and TIA! I have a query that uses 2 values from my form as criteria for
2 fields in the query. I can select the options and open the query. I can
base a form on the query and launch it from my criteria form with no
problem. However if I try to open a recordset object against the query from
this same criteria form I receive the (error # 3061 Too few parameters.
expected 2.). I've tried first opening the query from code, which worked
fine, then building my recordset, but received the same error. Any help is
appreciated.
Set db = CurrentDb()
Set rst1 = db.OpenRecordset("select * From [qryMyQry]")
--
Reggie
"Half this game is 90% mental."
----------