Duplicate selected records with a field with same value.

[pillaisg]

Selected records appearing in a subform shall be duplicated. While duplicating the records one field shall take the value from a textbox from the form.
Eg.
I am having a form with comboboxes where I can select shopname and the fruits supplied to that particular shop which are listed in the subform. The records in the subform shall be duplicated (sometimes selected records / all records) by keeping the new shopname based on a text box which I have assigned in the form.

[June7]

Exactly what is your question? Have you tried anything? What happens? What do you mean by 'duplicate'? What data should duplicate?

You could provide db for analysis. Follow instructions at bottom of my post.

[Welshgasman]

The subform records will already been linked from the shopID in the mainform, so you have everything you need in the subform.?

You could use the recordsetclone of the subform and walk that and insert new records with sql for any that have whatever way you are using for marking the ones that need to be duplicated?

[Bulzie]

I'm with June7, what's the question or issue you are having? What is your table(s) structure? So is it like:

Shop1 (main form key field) below fruits all on the subform?
Banana 10
Apple 2
Banana 3
Orange 4

[orange]

Pillaisg,
Perhaps you could show us an example or 2 of your expected output.

[Micron]

It reads like a class assignment given that there's no real question.

[madpiet]

Why not just grab the foreign key, use that to get the records you want, and then create the append query using that? the whole idea of using RecordsetClone (well, unless you're filtering by form or something) is just making a really simple question more complicated.

[Welshgasman]

Why not just grab the foreign key, use that to get the records you want, and then create the append query using that? the whole idea of using RecordsetClone (well, unless you're filtering by form or something) is just making a really simple question more complicated.

Well I was expecting that there would be some flag to indicate whether that record should be deuplicated or not?
That control would likely be unbound?, as no need to save it, so how would one do it via a query?