>Run-time error '3134'
>
>Syntax error in INSERT INTO statement
>
>I was trying to give an example of my INSERT INTO statement to keep it short, but here is the actual statement:
>
>

DoCmd.RunSQL (" insert into labels (trknum, BC2, <b>[Date]</b>, catalog, intid, _
>cavity, pressnum, cyclenum) values (" & mtxt0 & ", '" & mtxt9 & "', _
>#" & CStr(mtxt2) & "#, '" & mtxt4a & "', " & mtxt6a & ", '" & mtxt8a & "', _
>" & mtxt14 & ", " & mtxt18 & ")"

>
>sorry about the length of this

OK, I think the problem is with the field named Date, since it is a reserved word. Just enclose Date within brackets and it should work (see the changes in bold above)