Run-time error 3129 - Invalid SQL statement

[Scaniafan]

Good morning

I've got a small and probably easy-to-solve Monday-morning problem, giving me an headache and a run-time error 3129 (Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.)

Dim strSQLCollection As String
                    
            strSQLCollection = "SELECT QRY_Gross_Performance_Collection.* FROM QRY_Gross_Performance_Collection WHERE (((QRY_Gross_Performance_Collection.[Forwarding agent])='Test'));"
                    
            DoCmd.RunSQL "strSQLCollection"

What am I doing wrong here?

 

[JHB]

Remove the "

DoCmd.RunSQL [COLOR=Red][B]"[/B][/COLOR]strSQLCollection[B][COLOR=Red]"[/COLOR][/B]

 

[Scaniafan]

Aaaargh..... :banghead: Thank you!

 

[JHB]

Yes - Monday morning....!