Save existing form data as new record

[stucky]

Hi All,
Before I over think this one too much. I want to open an existing record via a form and then edit that data but save the form as a new record. Basically a form used for handover/takeover process where most of the data remains the same but the new form is the basis for the next handover/takeover.
Suggestions appreciated.

 

[Minty]

If you want to edit the data before copying it you would have to use an unbound form.
However if you find the record first then copy it as a new record then edit, you could use a bound form.

The unbound form is the safer way as the changes will only be committed if they press the copy & new button.

 

[gemma-the-husky]

I agree with this. one occasion when an unbound form is easier to use.

either that, or store the current record in a temporary table, and then append the temporary data to the real table. that way you get the benefit of a bound form too.

just easier than writing to the active table, and then having to remove a cancelled item

 

[stucky]

If you want to edit the data before copying it you would have to use an unbound form.
However if you find the record first then copy it as a new record then edit, you could use a bound form.

The unbound form is the safer way as the changes will only be committed if they press the copy & new button.

Thank you Minty, points me in the right direction.

 

[stucky]

I agree with this. one occasion when an unbound form is easier to use.

either that, or store the current record in a temporary table, and then append the temporary data to the real table. that way you get the benefit of a bound form too.

just easier than writing to the active table, and then having to remove a cancelled item

Thank you Gemma, I will be able to start off in the right direction.

 

[spikepl]

You may find this useful: http://allenbrowne.com/ser-57.html

I use it for copying orders and invoices (the latter as preparation for a credit note).

 

[stucky]

You may find this useful: http://allenbrowne.com/ser-57.html

I use it for copying orders and invoices (the latter as preparation for a credit note).

Thank you for the info and taking the time to reply spikepl.
Appreciated.