It looks like you're inserting field into the table from the same table? I think there's some sort of circular reference problem in that code.

+++ Rick ---

>Hi,
>
>I am getting an error a line very similar to the following. The error says "command contains unrecognize phrase/keyword".
>
>

>cSqlInsert = "insert into Mytable (fld1, fld2, fld3) values (?MyTable.fld1, ?MyTable.fld2, ?MyTable.fld3)"
>

>
>The list of fields is actually considerably longer. But what should I be looking at? TIA.