VBA to clone recordset then go to newly created clone

[tmyers]

Today seems to be a VBA kind of day.

I have a process that clones a recordset then prompts the user to name the newly create clone via an Inputbox.

I then typically use a combobox populated with the name of the original and all clones to navigate to each record. I however want to add in the code that after the clone is created, go to that record. This is to prevent the user from think the form is on the newly created clone, when it is in fact not until they select it in the combo.

I have the user value from the Inputbox as strinput.

I tried:

DoCmd.GoToRecord acDataForm, "JobQuote", acGoTo = "[RevisionName] = '" & strinput & "'"

But that failed.

What did a mess up on?

 

[theDBguy]

Hi. Not sure I follow. You may be using the terminology a little differently. As far as I know, you don't "name" a cloned recordset. Instead, you assign it to a recordset variable.

Are you maybe referring to a cloned record?

 

[tmyers]

The code takes the record and all child records and clones/copies them. I then use strinput to update a field [RevName] to identify it from the original. So all records are the exactly same (at time of creation) except for their [RevName] in the "master" table.

I then use a combo that is populated with the [RevName] that allows the user to navigate to each particular one. The code that creates all of this however, doesn't navigate/filter you to the newly created record and the time it finishes, which I think is unintuitive.

Does that help clear it up a little bit?

 

[theDBguy]

Does that help clear it up a little bit?

Yes, you are using the term "clone" to mean duplicating records. Access also has a method called RecordsetClone, which means something else.

 

[tmyers]

Yes, you are using the term "clone" to mean duplicating records. Access also has a method called RecordsetClone, which means something else.

Ah. I tend to use incorrect terminology a lot. Makes finding things via Google searches quite rough!

 

[theDBguy]

Ah. I tend to use incorrect terminology a lot. Makes finding things via Google searches quite rough!

For example, a Recordset is an object. It has a property called RecordsetClone, which is a copy of itself. But, that doesn't mean you'll now have double the number of records in your source table.

 

[tmyers]

I could believe it. The code I wrote out to do the cloning/copying is a monster. It is very long. It works though

 

[MajP]

Microsoft Access tips: Duplicate the record in form and subform

How to duplicate the current record on a form in a Microsoft Access database, along with the related records in the subform.

allenbrowne.com

 

[tmyers]

Microsoft Access tips: Duplicate the record in form and subform

How to duplicate the current record on a form in a Microsoft Access database, along with the related records in the subform.

allenbrowne.com

The code I use is actually based off this but changed a little bit. It does Pats method of DAO.AddNew.

 

[Kayleigh]

Found that code really useful @MajP ! But I am trying to copy records on forms with multiple subforms (related tables) - have enclosed a basic sample of what I'm working on...
Would really appreciate help on coding the cmdCopySession for this form.