Hi Im having trouble with this insert statement

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

MR_OS.gdbCurrent.Execute pstrDetailSQL
datOrderDetail1.RecordSource = "SELECT * FROM tblOrderDetail"
datOrderDetail1.Refresh

I know the variable glngNewOrderID is valid I used it
to populate a textbox. glngNewOrderID is of type long.
I also know the database is a valid open database

I get no error with that one but it does not insert a new record into that table. I have tried alot of different
syntax for the Insert and get syntax error messages among others.