Too few parameters expected one

[aman]

Hi there


I am getting runtime error 3061. Too few parameters expected one in the following line of code. The query itself works absolutely fine.

Set rs = CurrentDb.OpenRecordset("qry_FormsCat_CallAudit_CustomerOutcome")

Any help will be much appreciated.

Thanks

 

[Ranman256]

if this is a crosstab query and it references form objects, you MUST enter parameters
(via query design, parameters button, set refs: forms!myForm!txtBox , short text)

is it a crosstab?

 

[CJ_London]

it may be your query references a form for criteria - which you can't do when opening a recordset.

if this is the case, either build the full query sql in vba or remove the criteria in the query which relates to a form and put into your vba code e.g.

Set rs = CurrentDb.OpenRecordset("SELECT * FROM qry_FormsCat_CallAudit_CustomerOutcome WHERE somefield = " & forms!myForm!myControl)

 

[arnelgp]

And if it is an action query use

Currentdb.Execute