How to duplicate a specific record

[skelley]

Have users that are engineers putting engineering data in a database of "projects". They want the ability to copy engineering data from one record (project) to another and then modify to keep from having to key the data in everytime. How?

 

[TexasTJ]

Depends on how your database is designed and how your users operate it. One way would be a command button (copy data from an existing project) that is enabled only when in add mode. It could prompt the user for the project # they want to copy data from. Then have code set to copy the data from that project # into the blank form. It depends on how many pieces of data you have, how many tables are involved, etc., as to how to code the copying.