I have started putting the SQL statement into a separate string like this:
sSQL = "INSERT INTO Sales (nLot, sMonth, sDay, sYear, fAmount, sNote) " +_
"VALUES (" + sLotNumber + ", '" + sMonth + "', '" + sDay + "', '" + sYear + "', " + sTemp + ", '" + sNote + "')"
dbExecuteSQL(pDB, sSQL)
Not only does it make it easier to read, but you can pop the string into a message box to see exactly what the database engine is getting.
I too have used that technique before because it aids in troubleshooting.
LarryMc