I was able to get this to work
strSQL = "INSERT INTO tblCommissionsPaid ([ContractNumber], [RepID], [CommAmt], [CommDate], [CommTypeID]) " & _
"VALUES ('" & Me.ContractNumber & "', " & Me.RepID & ", " & Me.PurchAmt * 0.15 & ", " & _
" #" & Me.ContractDate & "#, 2)"
I'm still not sure if this...