Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Saving an Edited record as a new record

Status
Not open for further replies.

Trazzel

Programmer
Jul 10, 2003
11
US
I have a form that finds a record and allows edits. This form also allows me to add new records.

However, for tracking purposes, I would like to save the edited record as a new record. The "find a record" approach allows me to capture the demographic data that has already been submitted.
 
Using Command Button Wizard you can choose the option to add a command button that Duplicates the record with just one click.
The button has some piece of code in the 'On click' event that performs the duplication.........

T. Blom
Information analyst
tbl@shimano-eu.com
 
Thank you for the response. However, I had tried the duplicate command and it does not save the record. It will give me an error message.
 
How do you store the records. Do you use autonumber as a primary key? If not you may have a primary key violation...

T. Blom
Information analyst
tbl@shimano-eu.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top