Good day, I really hope someone can help to point me in the right direction.

I have a form with a sub-form, in the sub-form users can insert new records for items that they want, almost like a shopping list.   The sub-form is populated through a Lookup Field from the Item list.   This part works well.

I would LIKE to first take the user to a Report that show all the Items available.   I then want the user to select the items from the list / report and then click on a button to take them to the form above and auto-populate the sub-form with the selected items.

I hope someone can help?   I hope it is even possible.

Thanks
Henk