SQL not updating record

[jgelpi16]

I have the below SQL running. I have a table with the date values and the field name matches. Whenever it runs nothing gets inserted into the field. I even have a msgbox displaying after the fact showing the value of the variable....value is present in the variable. I do have the values in the table defaulted to 0. Thanks in advance for the help.

    mySQL = "UPDATE tblDivBreakdown SET [HSLC00_Div5]=" & vFieldVal & " WHERE [BegWk]=#" & vBegWk & "#"
    CurrentDb.Execute mySQL, dbFailOnError

[jgelpi16]

Did not have date field in table set as date/time...