Yes I thought of that and tried it without out and it still does not work

pstrDetailSQL = "INSERT INTO tblOrderDetail " & _
"(fldOrderID)" & _
" VALUES (glngNewOrderID)"

I tried it several other ways and still no luck.