>No dice, I am still getting the error.
>
>The field for the insertion is Date/Time
>I have dimmed the memvar as date and stored Date to it.

Sorry, mental lapse, you should CStr() the variable before concatenating. The following should work:

Dim dVar As Date
dVar = Now
DoCmd.RunSQL "Insert Into myTable (Column1, column3, Column4) Values (9, 'Myname', #" & CStr(dVar) & "#)"

HTH