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.