Guest_imported
New member
- Jan 1, 1970
- 0
Hi,
When opening the recordset, opening a table, no problem.
When opening the recordset, opening a query I get 'Too few parameter, expected 1'
Any ideas?
Heres the code
Dim dbs As Database
Dim rst_etracker As Recordset
Dim etracker_criteria As String
Set dbs = CurrentDb
Set rst_etracker = dbs.OpenRecordset("SELECT * from qry_etracker_check_hours"
When opening the recordset, opening a table, no problem.
When opening the recordset, opening a query I get 'Too few parameter, expected 1'
Any ideas?
Heres the code
Dim dbs As Database
Dim rst_etracker As Recordset
Dim etracker_criteria As String
Set dbs = CurrentDb
Set rst_etracker = dbs.OpenRecordset("SELECT * from qry_etracker_check_hours"