>still no luck...the exact code from my module are:
>
>

Dim mtxt2 as Date
>mtxt2 = Date
>
>DoCmd.RunSQL ("insert into labels (fld1, fld2, DATE) values (" & mtxt0 & ", '" & mtxt1 & "', #" & CStr(mtxt2) & "#)")

>
>[labels].[date] is type: Date/Time

I ran this code and it works fine, what's the error message you get?

As you have it, mtxt0 would be a numeric value in a string var, mtxt1 a string, and of course mtxt2 as date.