E
Eddy
I am trying to open a recordset of a query that has some Criteria. I am
using the following code:
Set rsTot = db.OpenRecordset("qryTotal", dbOpenDynaset)
The qryTotal has criteria so it opens to a specific record. In the criteria
for a field I have:
=Form1!Field1
When the code attempts to open the record set I get the error "Too Few
Parameters, Expect 1"
My question is how or can I include the parameters in the Set statement
above so the code can open the qryTotal and set the recordset?
Thanks
using the following code:
Set rsTot = db.OpenRecordset("qryTotal", dbOpenDynaset)
The qryTotal has criteria so it opens to a specific record. In the criteria
for a field I have:
=Form1!Field1
When the code attempts to open the record set I get the error "Too Few
Parameters, Expect 1"
My question is how or can I include the parameters in the Set statement
above so the code can open the qryTotal and set the recordset?
Thanks