How can i write the date here?

[robhargreaves]

Can anyone tell me how to write a date to a one cell table named tbllastsync the field name is datelastsync

it looks like this

datelastsync
01/01/2005

the table has no primary key I just want to store a date there so if it were updated now I would like to update it following the running of some code so...

datelastsync
13/03/2005

Thanks for your help,

Rob

 

[WayneRyan]

Rob,

DoCmd.RunSQL "Insert Into tbllastsync(datelastsync) Values(#" & Date & "#);"

Wayne