How can i UPDATE a column with a value input in tht FORM?

[kwokv616]

CurrentDb.Execute "UPDATE ValuationDate SET Valdate = Forms![MainScreen].[InputDate].Value;"

tmpvaldate = Forms![MainScreen].[InputDate].Value
CurrentDb.Execute "UPDATE ValuationDate SET Valdate = tmpvaldate;"

both of them didnt work...=(

 

[DCrake]

No they won't you have to structure you code as such

CurrentDb.Execute "UPDATE ValuationDate SET Valdate = #" & Forms("MainScreen")("InputDate") & "#"

tmpvaldate = Forms("MainScreen")("InputDate")
CurrentDb.Execute "UPDATE ValuationDate SET Valdate = #" & tmpvaldate & "#"