Update query not updateing Date

[Trevor2007]

Update query should update the date field in a table but does not, I try printing off with debug.print and no results

DoCmd.RunSQL "UPDATE IndividualSettingsTbl SET IndividualSettingsTbl.Date = #" & stDate & "# " & _
"Where IndividualSettingsTbl.UserName = 'ZMoor';"

[whitbacon]

Try debuging as follows

dim sql as string

sql = "UPDATE IndividualSetti ngsTbl SET IndividualSetti ngsTbl.Date = #" & stDate & "# "
sql = sql & "Where IndividualSetti ngsTbl.UserName = 'ZMoor';"
debug.print sql

docmd.runsql sql