Runtime Error 3061

[mlrucci]

Good morning, I am a bit confused. I have vba code to run an append qry upon pressing a button on a form. (the code is in a qry not vba sql) For some reason, I am getting Runtime error 3061 Too few parameters. Expected 2
Here is the code.

INSERT INTO tblAppImportFM_ConCon ( ProductID )
SELECT tblImportFM_ConCon.CalcType AS ProductID
FROM tblImportFM_ConCon
WHERE (((tblImportFM_ConCon.CalcType)=37) AND ((tblImportFM_ConCon.[CC Application Date]) Between [Forms]![frmImportFM_ConCon]![dtInvoiceFirst] And [Forms]![frmImportFM_ConCon]![dtInvoiceLast]));

Here is the funny thing which is throwing me off, if I execute the append qry without going through VBA, it works great. Using the form to execute the append qry gives me the error. The form with the date range is open. Not sure where the problem is located. Any help would be appreciated.

Thank you

[Welshgasman]

Is frmImportFM_ConCon open ?

[mlrucci]

Yes. I even tried to move the location to another open form to see if it was corrupt Weird!!!

[CJ_London]

what VBA code are you using to execute the query? .execute? .runsql?

could be wrong but seem to recall that with one of them the query can't include parameters such as your form references

[mlrucci]

I am using execute. Let me try to do it via sql

[Welshgasman]

I know there are ssues when you use the query in a recordset?
https://www.access-programmers.co.uk.../#post-1653079

However I thought form controls in a query were fine, though I tended to use tempvars ?

[mlrucci]

That was it!! I converted the qry to sql and executed the append qry in vba. Works perfectly. Thanks for the insight!!!

[Micron]

Hmm, I didn't chime in because you said

(the code is in a qry not vba sql)

but now say

I converted the qry to sql

Access queries are based on a sql syntax (albeit specific to Access). I think you meant you had formed a sql statement and were trying to execute it using vba? Code sql statements are not processed by the same part of Access so you cannot use things like Forms!frmMain... without concatenation. That is, such object references cannot be part of the literal string that comprises actual sql.