I am trying to open a recordset using Set rstTurnoverBreakout = db.OpenRecordset("qryQDVL_TOBreakout") in the click event of a button on a form. qryQDVL_TOBreakout is based on a query that uses a combobox from the same form as criteria. I am getting the following error: Run-time error '3061': To few parameters. Expected 1.
If I remove or hard code the criteria, the code runs fine. If I open the query, either directly of in code using docm.openquery, it works fine with the crieria.
Any ideas as to why the parameter is not found when using OpenRecordset and/or possible solutions would be appreciated.