Save selected record as a new (1 Viewer)

[peti8788]

Hi,

I have a form which I used to save records to a table. The form has a dropdown list with a select query, to select any record in the table. I would like to save records as new records after some editing with the .addnew command, but it overwrites the existing record, and then adds a new record too. What can I do with that?

 

[June7]

What you have to do is use code to populate a new record with data from found record and allow user to edit newly created record.

Another approach is to set DefaultValue property of each control for data you want to carry forward. Then as soon as user starts edit of any control on new record row, default values will populate.

 

[peti8788]

Thanks for your reply
how could I populate the new record, and allow the user to edit?

 

[arnelgp]

instead of saving the edited record as new record (which in my opinion will require more vba), why not add a button that will Copy the record as New Record and edit it from there.

 

[June7]

Review

https://stackoverflow.com/questions/1003048/copying-a-record-in-vba-2-the-new-question

copy record as a new record - Microsoft Access / VBA

copy record as a new record. Microsoft Access / VBA Forums on Bytes.

bytes.com