J
Jason
I am not sure I understand your problem completely. It sound like you're copying all of the values in one record and then adding a newing record with those copied values. If this is the case, then copy only those field values that you want, add a new record, inserting those copied values, and let the autonumber data type generate your record id. Use your Microsoft Help, and study the possibilities that autonumber allows. Additionally, instead of duplicating you might try simply adding a default value to the desired fields at the table level. Then whenever you add a new record the default values are automatically inserted, a record id is automatically generated, you can add or change data at will, and I guarantee you your program will not shutdown (unless you have a virus).