Make new records if an field changes

[ownlikeaboss]

So i have an field which you can check off.
Once checked off it should generate a new record with almost exactly the same data.
How can i do this?

[rpeare]

Does your data entry form use a query or table that has a Primary Key field? if it does you can create an APPEND query that pulls information from the current record (determined by looking up information related to the current record) and appending that to the table you want.