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.
His coverage is so extensive and comprehensive that many of the articles have been used by Access in the MSDN! It's always my first stop when I'm looking for a solution to an Access problem and his solutions are always spot on!