cenderawasih
MIS
Hi all...
I have a program that requires to open the recordset of a query where the query has a few criteria. This is the coding:
dim rstQryEmployee as DAO.Recordset
set rstQryEmployee=CurrentDb.OpenRecordset_
("QryEmployee", dbOpenDynaset)
The above codes works fine for opening a table or a query that doesn't have criteria, but in my case the QryEmployee has criteria like:
in Date Field,the query criteria=Forms!FrmEmp!DateTest.value
The error msg is: Too few parameters.expected 2
I hope someone can help me out with this problem....the query to be opened MUST have the specified criteria....
thank you
I have a program that requires to open the recordset of a query where the query has a few criteria. This is the coding:
dim rstQryEmployee as DAO.Recordset
set rstQryEmployee=CurrentDb.OpenRecordset_
("QryEmployee", dbOpenDynaset)
The above codes works fine for opening a table or a query that doesn't have criteria, but in my case the QryEmployee has criteria like:
in Date Field,the query criteria=Forms!FrmEmp!DateTest.value
The error msg is: Too few parameters.expected 2
I hope someone can help me out with this problem....the query to be opened MUST have the specified criteria....
thank you