Error 3061 and AutoNumber field.

[weightinwildcat]

I am capturing information and field names from an existing record in a pair of arrays. After processing the array with the data I want to be able to insert this as a new record. One of the fields is an AutoNumber field, so I do not want to try and insert a value for this one. I can string together an append query, but when I try to run it I get error number 3061 - Too few parameters. Any thoughts on what to do?

 

[MajP]

You need to do a debug.print to show your SQL. You have a problem in query syntax.

 

[PWise]

what is the sql of the query