Saving and Altering Records

[blair in sydney]

Hi.

I am working on the following process, and I am stuck at the bold faced step:

Take an existing Record, displayed on my form.
alter it
save it as a new record

I have been playing around with the following codes

I don't know the syntax, but I would be after something along the lines of
DoCmd.Save as New Record, (Don't change this one) ??

Thanks in Advance.

[FishVal]

Hi.

I am working on the following process, and I am stuck at the bold faced step:

Take an existing Record, displayed on my form.
alter it
save it as a new record

I have been playing around with the following codes

I don't know the syntax, but I would be after something along the lines of
DoCmd.Save as New Record, (Don't change this one) ??

Thanks in Advance.

I can suggest the following.

 
Private Sub Command4_Click()
    With DoCmd
        .RunCommand acCmdSelectRecord
        .RunCommand acCmdCopy
        .GoToRecord acActiveDataObject, , acNewRec
        .RunCommand acCmdPaste
    End With
End Sub
 
 

[blair in sydney]

Thanks. That's getting there, that seems to
create the new record, however it updates the old record as well.
Any thoughts on that?

[missinglinq]

In what way does the code FishVal posted update your original record?

[FishVal]

Thanks. That's getting there, that seems to
create the new record, however it updates the old record as well.
Any thoughts on that?

I've tested this. It works fine at least with two controls on the form: one combo and one text.
Actually it performs old good Copy/Paste. Did you test it?

[missinglinq]

I think I've figured out what going on! Blair's altering the original record, then running FishVal's code! That's why it updating the original! Blair, you need to run FishVal's code, then alter the new, just created record!

The only problem I see with your code, FishVal, is that I think it'll bomb if any of the controls hold a field that is a Primary Key, as it'll be creating a duplicate.

[blair in sydney]

I just tested it again.

I used the nav arrows to go back to an old record.I have a comments box on my form, and I changed the comment from "test 1" to "test 2". The new record
is generated with the comment "test 2", however the original form/record is changed such that the comment now reads "test 2" as well.

Thanks for thinking about this guys.

[blair in sydney]

yep, you figured it out while i was writing my response. cool.

[missinglinq]

Glad you got it working!