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.