Form’s Date Value not able to bring it over to VBA

I have a query, called “RosterQC” that filters results based on the text object “Text35” in the Form “Quality”:

SELECT Record No FROM TableX WHERE Date = [Forms]![Quality]![Text35]

Running the query itself is fine, but when I try to run it on VBA. It gives me an error 3061 – too few parameters expected 1. My VBA code as of below,

Sub Duplicate() DoCmd.RunSQL “Delete * from old_table” CurrentDb.Execute “Insert Into old_table Select RosterQC.* From RosterQC” DoCmd.OpenReport “RosterQC_Report”, View:=acViewPreview End Sub

Appreciate if someone please give help me by providing me with some insights or solutions? Thanks.

submitted by /u/georgetown15
[link] [comments]

Posted on