>What is the syntax for inserting a memory variable dimmed as Date into a table.
>For example:
>
>Number = " & numvar & "
>Text = '" & textvar & "'
>Date = ????
>
>My statement is similar to the following:
>

Dim mvar1 as Integer
>Dim mvar2 as String
>Dim mvar3 as Date
>
>mvar1 = Me!text1.value        (Number of Cycles)
>mvar2 = Me!text2.value        (Part #)
>mvar3 = Me!text3.value        (Production Date)
>
>Insert into mytable(fld1, fld2, fld3) values(" & mvar1 & ", '" & mvar2 "', ????
>

>
>Any help would be appreciated

Try Date = #" & textvar & "#