You were given a potential solution here:
i need move all selctead item from combo box to another combo box
www.access-programmers.co.uk
What didn't work about that?
This solution is not quite what I want
I want when I select an item from a listbox whose data source is a table, move to another listbox and all records move to another table.
If you notice the image, only the name of the analysis is transferred, apparently to the second list box, but in reality, it transfers all the records related to this item, such as the price field, which appears in the image to be collected in the main form, and this is what I want.