views:

459

answers:

0

Good Day,

I have 2 sub-data-sheets on a form,

"products and trolley" the products sub-form displays all products. I need the trolley sub-form to display all selected products,

I need a macro of some sort that when a product is clicked (in sub-form) it saves/copies that product to the items field in the trolley sub-form(Duplicates OK). Both sub-datasheets are on the same form.

(copying from 1 field in 1 table to another field in another table, both tables are on the same form)

Or is there any other way

There is a similar question, but the answer to that question, is not what i'm look for

Thank You