Update Query "Too few Parameters"

[teambond]

Hi,

This is going to seem so easy but I cannot get this simple update query to work.

UpdateProcess = "UPDATE OrderDetailT SET DepSubCompl =" & Date & " WHERE ID=" & Forms![JobCardandSignoffF]![ID]
CurrentDb.Execute UpdateProcess

If I run the debug over it UpdateProcess comes out correctly as
"UPDATE OrderDetailT SET DepSubCompl = 02-Jun-2013 WHERE ID=56"
which is correct, but when it executes it gets this error.

Can someone help please?

Thanks.

 

[pbaldy]

For starters, a date value needs to be surrounded by #.