Duplicating Form and Subform records

[imsuneaik]

Hi everyone,

I am trying to duplicate my main form and sub form records. By using queries, i was able to make the duplicate the record for the main form as they are from the same table (eg. No. 150 and No. 151)


I have 2 tables named List and Item, linked by ID as their relationship.

- Record from the Main Form (List)
- SubForm (List) that displays records of Items (from table) tagged by their ID.

When I open the subform of the newly duplicated record with has an auto increment (eg. 151), I wasnt able to find the records of items, since they are still tagged under their previous ID (eg.150) in the Items table.

May I check if there's a workabout to this problem? Thanks

 

[arnelgp]

you use query also to duplicate the subform table:

insert into subTable (LinkingField, otherfield, otherfield) select 150, T.otherfield, T.otherfield from subTable As T where T1.LinkingField = 150;

 

[Uncle Gizmo]

Not sure if this is the answer you are looking for, but I thought it might give you some ideas.

I answered a similar question recently. The OP wanted to be able to create a set of similar records in the subform.

See this blog:- Subform Record Duplicator:-

https://www.niftyaccess.com/subform-record-duplicator/

Sent from my Pixel 3a using Tapatalk

 

[missinglinq]

Allen Browne has a well-written tutorial on this very subject found here:

http://allenbrowne.com/ser-57.html

Linq ;0)>

 

[imsuneaik]

Thank you all. It works already! Much appreciated.