Re: Copy Data from One Subform to another Subform.
I do the same and similar things now in my Accounting systems.
There as tow way=s I do it.
1) Use an append query. Great for copying records.
2) Use a recordset. Great for duplicating a record(s) and the related child records.
For your example, the way I do it is with a popup form. This displays the item along with any controls the user can change, like quantity. When the user clicks "Save" it runs the append query to add the record.
Specializing in Accounting, CRM, and Business solutions
Microsoft Access MVP 2010-2015 , aka
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.