vbShortDate - Updating a Record

[charlie1111]

Hey folks!

I have a field in a table set to 'Data/Type'=Date/Time & 'Format'=ShortDate'.

On my form, I have a TextBox with the Format set to ShortDate.

Once the user changes the data, I take the data and write a query to update the record. It seems no matter what I do, the date gets written to the table in a date AND time format (usually with the year 1899..)

I've tried writing the query with
....table_vehicles.date =" + Forms!VehicleEntry.date +"

and I've tried ...table_vehicles.date =" + FormatDateTime(Forms!VehicleEntry.date, vbShortDate) +"

and I even tried setting the table field to text, and the form as ShortDate..

I know there is something simple that I'm missing

Anybody got some help?

Regards,
Charlie

 

[Zion7]

You forgot your qualifiers!

Dates....."#1/1/06#"
Strings...."'Hello'"
Numbers.... 7


table_vehicles.date =#" $ Forms!VehicleEntry!date & "#"

 

[charlie1111]

Yes! Yes! Thank you. Sometimes it's hard to see the forest thru the trees....