Creating a Duplicate Record from a Template

Posted by JohnH on August 20, 2001 8:10 AM

I use a template for data entry to create records in a database.
Sometimes the new record contains information similiar to the previous record so I would like to save the users time by having the duplicate fields automaticaly filled instead of retyping them in.

The sequence I use right now is:

User opens the template, fills in the information, Click a button to Save as to push the record into the database.
Then click a button to create a new record (Macro to open the Template again)

Any Help will be appricated.

Thanks.

John

Posted by JohnH on August 21, 2001 10:50 AM

Problem Solved

Two ways of doing this.

1. After the initial record has been pushed to the database you can many any changes to the record on screen and use Select Save from the File Menu. It will remind you that you have already save this record before and allow you to either save the record with the changes you have made or Save it as a New Record.

2. Create a Macro to do step number 1 using SendKeys and allow user to decide.

Thanks.

John