Can someone help me, I have an access form with multiple sub-forms on it that saves in multiple tables. A person goes in this form and enters all the information on a specific job, unfortunately many times the same information may be put in multiple times. Same client, same address, etc. We would love to be able to have a command button that would copy an existing record and create it with a new ID (basically a copy and paste) and then we can go in and just change the items that need to change. (VBA) Right now the data goes to a Property table, Invoice table, Client table, etc. and there is a sub-form for each of these. Thank you for your help.