[AccessD]

I need someone to unlock my brainjam!

"strNewEventName" is a string variable I need to insert in this statement
and after a half an hour I can't seem to get the syntax correct.

DoCmd.RunSQL "INSERT INTO tblEvent ( fldName, " & _
            "fldEvTypeID, fldOccur, fldLocation, " & _
            "fldDesc, fldDeptID, fldRecorded, " & _
            "fldStaffID ) " & _
            "SELECT strNewEventName AS fldName, tblEvent." & _
            "fldEvTypeID, tblEvent.fldOccur, tblEvent." & _
            "fldLocation, tblEvent.fldDesc, tblEvent." & _
            "fldDeptID, tblEvent.fldRecorded, " & _
            "tblEvent.fldStaffID " & _
            "FROM tblEvent;"

TIA
JB