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 category SET date=" & Forms![main form]!txtDate.Value)
I don't see anything wrong but it keeps me returning error

And If I use US format update works but with date 31.12.1899

[hertfordkc]

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 category SET date=#" & Forms![main form]!txtDate.Value&"#")
I don't see anything wrong but it keeps me returning error

And If I use US format update works but with date 31.12.1899

I'm guessing that txtDateValue is a 'string' rather than a 'date'.

[vojinb]

Hi,
txtDateValue is date formatted. In format properties of text field I choose short date (as in database table) and calendar appears from side of control .

[hertfordkc]

Did you notice the change that I suggested for your code?

[vojinb]

Did you notice the change that I suggested for your code?

Hi, did not till now ). Tried also with # but without success

[hertfordkc]

Suggest you debug.print or otherwise check the value of 'txtdate.value'

[alansidman]

Crosspost: https://www.accessforums.net/queries...ble-19978.html