Copy Records From Previous RecordInto New Record

[batowl]

Hi All,

I have been given an old, poorly constructed database and asked to make some modifications to it for some colleagues. Long story short, I need to find a way to allow the users to press a button on a form and have a subset of fields on the new record filled with the identical entries as the fields in the previous record. Could someone please guide me on how to do that? Thank you.

[rpeare]

Where are the records, are the in the main form or in a subform? And most importantly does the table you're access have a primary key, so that when you're in your subform you can reference it by looking the data based on that PK, finally would this only be used when creating new records or could it be used for updating existing records as well? What you're asking for is fairly complex if you're using a bound form, but pretty easy if you're using an unbound form as well so that would make a difference as to how you would approach this.

[batowl]

For this particular problem, there is only one form that is based off of one table (no subforms). There is no primary key for this table. The table is related to other tables in the db (which are not on the form) but referential integrity is not enforced among any of these tables.

And the users would only use this button when performing data entry on new records.

[June7]

Is this what you want http://www.everythingaccess.com/tuto...-to-new-record

[batowl]

Thanks for the tip, but that is not working for me. I did find a solution for starting a new record with data from the current record and that could work for me if I can find a way to carry over data for more than one field. Any suggestions for how to add multiple fields to this code so that when Command 30 is pressed, a new record is created with fields carried over from more fields than just [Beginning Date]?

Private Sub Command30_Click()
With Me.RecordsetClone
.AddNew
![Beginning Date] = Me.[Beginning Date]
.Update
Me.Bookmark = .LastModified
End With
End Sub

[June7]

You could just do the same thing as you have for the one, all sequentially in the same procedure.

Other methods, review:

http://allenbrowne.com/ser-24.html
http://allenbrowne.com/ser-24a.html
https://www.accessforums.net/forms/c...elp-28316.html

[batowl]

Ugh, there was a spelling difference between the form and the table, which made the code incorrect. Now it works. Solved.