Copy Record With VBA (Access 2000)

I want to create a new record by clicking on a button in a form. The record
needs to copy the data from the form's current record in all fields but one
(a unique index field). The button wizard has a copy record option, but it
doesn't seem to work.

I think I know how to do this with an SQL statement (INSERT), but I would
have to change the SQL every time a field is added to the table, and there
are many fields in the table, so I would rather not do this unless there is a
way to automate it.

It seems like this should be fairly straight-forward with the recordset
object, but I have not been able to figure it out. Any of you experts know
how to do this? Thanks in advance!
.

Loading