open recordset

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sorry, I hit the wrong button a second ago.
I am getting an error "too few parameters, expected 1" with the following
code. When I check the SQL statement it looks fine and the query
"pqQuickSearch" executes fine when I open it from the query pane. The second
line below turns yellow. Any ideas what I need to check?

strSQL = CurrentDb.QueryDefs("pqQuickSearch").SQL
Set rs = CurrentDb.OpenRecordset(strSQL)

Thanks!!
 
Back
Top