>Any idea why I get a syntax error when I change:
>
>

DoCmd.RunSQL ("INSERT INTO temp_mold Select trknum, sysdate, catalog From Product where trknum=" & Me.Text53 & ";")

>
>to
>
>

DoCmd.RunSQL ("INSERT INTO temp_mold Select trknum, sysdate, _
>catalog From Product where trknum=" & Me.Text53 & ";")

>
>
>The first example works fine. The only thing different in the second is the line continuation but it errors out. Thanks in advance for any help

I believe for strings you need to close the first line and concatenate the second line for this to work:

DoCmd.RunSQL ("INSERT INTO temp_mold Select trknum, sysdate," _
    & "catalog From Product where trknum=" & Me.Text53 & ";")

HTH