Hi,
I am trying to open a query recordset but I am getting the following error: "Run-time error '3061': Too few parameters. Expected 1."
I have the following code:
Dim rst1 As DAO.Recordset
Set rst1 = CurrentDb.OpenRecordset("SELECT * FROM [Product Info Query] WHERE [Job] = '" & [Job_Number] & "'")
[Job_Number] is a string of text btw.
I have a feeling it has to do with the fact that the query I am trying to refer to has "[Forms]![Order Info]![Job_Number]" as the criteria for [Job]. When I remove the criteria from the query, my lines of code works.
Any ideas on why I am getting this error? When I hover over [Job_Number], it does yield the correct string I am trying to filter. Thanks