Bingo - It's amazing how you (or should I say I) can stare at a line of code and all of a sudden the error is obvious. The last line of the INSERT SQL command contained an IIF statement. I had a ) ending the IIF statement but forgot to add another one for the SQL command. Now is works fine.
Thank you all for your help.