Modules & VBA :: DateTime Format - Update Timestamp With Todays Date When User Make Changes

I am new to access 2010. I have a table called "Forecasts", and I wish to update the timestamp with todays date, whenever the user makes a change to the qty of goods forecasted.

I have been researching online for the solution to the correct format to datetime, but it doesnt seem to work.

Code:
Dim todayDate As Date
todayDate = Date
Dim sqlString As String
sqlString = "UPDATE [Forecasts] " & _

[Code] .....

The messagebox shows:

UPDATE [Forecast] SET Branch_Plant=123, Item_Number_Short='222', Description='AAA', UOM='EA', Estimated_Cost=123, Requesting_Business_Unit='AAA', End_Customer='CCC', Project ='Secret', Timestamp=#26/12/2013# WHERE ID =24

Then I hit a syntax error. Whats wrong with sqlString?