cannot update date in table

[vojinb]

Hy,
I have a table having one date field formatted as short date "15.12.2011", and on a form text box formatted as short date format. When I click on text box calendar appears and I choose proper date, but when I want to update date in table via query it returns error.
My query looks like:
CurrentDb.Execute ("UPDATE kategorija SET datum=" & Forms![Glavna Forma]!txtDate.Value)
I don't see anything wrong but it keeps me returning error

 

[pbaldy]

Try

CurrentDb.Execute ("UPDATE kategorija SET datum=#" & Forms![Glavna Forma]!txtDate.Value & "#")

 

[vojinb]

Thanks,
but still receive error:
Run-time error '3075':
Syntax error in date in query expression '#07.12.2011'.

 

[pbaldy]

Might help to know what the error is.

Could be because in code Access requires dates in US format:

http://allenbrowne.com/ser-36.html#Format
http://access.mvps.org/access/datetime/date0005.htm